CMP_ASG_SALARY_SIMPLE_CMPTS

Details

Schema: FUSION
Object owner: CMP
Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID SALARY_ID DATE_FROM DATE_TO SALARY_BASIS_NAME SALARY_BASIS_TYPE DISPLAY_SEQUENCE COMPONENT_TYPE_NAME SIMPLE_COMPONENT_CODE COMPONENT_NAME BASED_ON_COMPONENT_CODE DEPENDENT_COMPONENT_NAME RATE_AMOUNT ANNUAL_AMOUNT ANNUAL_FT_AMOUNT DEFAULT_VALUE OVERALL_SALARY_IMPACT USER_SELECTED_COMPONENT OVERRIDE_GSP_RATE MINIMUM_VALUE MAXIMUM_VALUE SALARY_BASIS_ID BASIS_SIMPLE_COMPONENT_ID PROCESSING_SEQUENCE COMPONENT_TYPE

Name

PERSON_ID

ASSIGNMENT_ID

SALARY_ID

DATE_FROM

DATE_TO

SALARY_BASIS_NAME

SALARY_BASIS_TYPE

DISPLAY_SEQUENCE

COMPONENT_TYPE_NAME

SIMPLE_COMPONENT_CODE

COMPONENT_NAME

BASED_ON_COMPONENT_CODE

DEPENDENT_COMPONENT_NAME

RATE_AMOUNT

ANNUAL_AMOUNT

ANNUAL_FT_AMOUNT

DEFAULT_VALUE

OVERALL_SALARY_IMPACT

USER_SELECTED_COMPONENT

OVERRIDE_GSP_RATE

MINIMUM_VALUE

MAXIMUM_VALUE

SALARY_BASIS_ID

BASIS_SIMPLE_COMPONENT_ID

PROCESSING_SEQUENCE

COMPONENT_TYPE

Query

SQL_Statement
select csa.person_id ,csa.assignment_id ,csa.salary_id ,csa.date_from ,csa.date_to ,csb.salary_basis_name ,csb.salary_basis_type ,bsc.display_sequence ,hl1.meaning as component_type_name ,bsc.simple_component_code ,hlk.meaning as component_name ,bsc.based_on_component_code ,hl2.meaning as dependent_component_name ,ssc.amount as rate_amount ,ssc.annual_amount ,ssc.annual_ft_amount ,bsc.default_value ,bsc.overall_salary_impact ,bsc.user_selected_component ,bsc.override_gsp_rate ,bsc.minimum_value ,bsc.maximum_value ,bsc.salary_basis_id ,bsc.basis_simple_component_id ,bsc.processing_sequence ,bsc.component_type from cmp_salary csa ,cmp_salary_simple_compnts ssc ,cmp_basis_simple_components bsc ,cmp_salary_bases_vl csb ,hcm_lookups hlk ,hcm_lookups hl1 ,hcm_lookups hl2 where csa.salary_basis_id = csb.salary_basis_id and csa.salary_id = ssc.salary_id and csa.assignment_id = ssc.assignment_id and ssc.basis_simple_component_id = bsc.basis_simple_component_id and csb.salary_basis_type = 'ORA_SIMPLE_COMPONENTS' and csb.salary_basis_id = bsc.salary_basis_id and csb.salary_basis_type = 'ORA_SIMPLE_COMPONENTS' and hlk.lookup_type = 'ORA_CMP_SIMPLE_SALARY_COMPS' and bsc.simple_component_code = hlk.lookup_code and hl1.lookup_type = 'ORA_CMP_SIMPLE_COMPONENT_TYPES' and bsc.based_on_component_code = hl2.lookup_code (+) and hl2.lookup_type (+) = 'ORA_CMP_SIMPLE_SALARY_COMPS' and bsc.component_type = hl1.lookup_code order by csa.assignment_id, csa.date_from,ssc.display_sequence

SQL_Statement

select csa.person_id

,csa.assignment_id

,csa.salary_id

,csa.date_from

,csa.date_to

,csb.salary_basis_name

,csb.salary_basis_type

,bsc.display_sequence

,hl1.meaning as component_type_name

,bsc.simple_component_code

,hlk.meaning as component_name

,bsc.based_on_component_code

,hl2.meaning as dependent_component_name

,ssc.amount as rate_amount

,ssc.annual_amount

,ssc.annual_ft_amount

,bsc.default_value

,bsc.overall_salary_impact

,bsc.user_selected_component

,bsc.override_gsp_rate

,bsc.minimum_value

,bsc.maximum_value

,bsc.salary_basis_id

,bsc.basis_simple_component_id

,bsc.processing_sequence

,bsc.component_type

from cmp_salary csa

,cmp_salary_simple_compnts ssc

,cmp_basis_simple_components bsc

,cmp_salary_bases_vl csb

,hcm_lookups hlk

,hcm_lookups hl1

,hcm_lookups hl2

where csa.salary_basis_id = csb.salary_basis_id

and csa.salary_id = ssc.salary_id

and csa.assignment_id = ssc.assignment_id

and ssc.basis_simple_component_id = bsc.basis_simple_component_id

and csb.salary_basis_type = 'ORA_SIMPLE_COMPONENTS'

and csb.salary_basis_id = bsc.salary_basis_id

and csb.salary_basis_type = 'ORA_SIMPLE_COMPONENTS'

and hlk.lookup_type = 'ORA_CMP_SIMPLE_SALARY_COMPS'

and bsc.simple_component_code = hlk.lookup_code

and hl1.lookup_type = 'ORA_CMP_SIMPLE_COMPONENT_TYPES'

and bsc.based_on_component_code = hl2.lookup_code (+)

and hl2.lookup_type (+) = 'ORA_CMP_SIMPLE_SALARY_COMPS'

and bsc.component_type = hl1.lookup_code

order by csa.assignment_id, csa.date_from,ssc.display_sequence