CMP_ASG_SALARY_RATE_COMPTS

Details

Schema: FUSION
Object owner: CMP
Object type: VIEW

Columns

Name
BUSINESS_GROUP_ID LEGISLATIVE_DATA_GROUP_ID PERSON_ID WORK_TERM_ID ASSIGNMENT_ID ASSIGNMENT_TYPE SALARY_ID DATE_FROM DATE_TO SALARY_BASIS_ID SALARY_BASIS_NAME RATE_DEFINITION_ID RATE_DISPLAY_SEQUENCE RATE_NAME RATE_FACTOR RATE_AMOUNT FTE_FLAG RATE_ANNUAL_AMOUNT RATE_ANNUAL_FT_AMOUNT RATE_CURRENCY_CODE RATE_FREQUENCY_CODE RATE_FREQUENCY_NAME LEGISLATION_CODE RATE_SCALE RATE_ROUNDING_CODE RATE_ENTERABLE RATE_FACTOR_ENTERABLE RATE_BASE_SALARY_FLAG RATE_OVERALL_SALARY_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY

Name

BUSINESS_GROUP_ID

LEGISLATIVE_DATA_GROUP_ID

PERSON_ID

WORK_TERM_ID

ASSIGNMENT_ID

ASSIGNMENT_TYPE

SALARY_ID

DATE_FROM

DATE_TO

SALARY_BASIS_ID

SALARY_BASIS_NAME

RATE_DEFINITION_ID

RATE_DISPLAY_SEQUENCE

RATE_NAME

RATE_FACTOR

RATE_AMOUNT

FTE_FLAG

RATE_ANNUAL_AMOUNT

RATE_ANNUAL_FT_AMOUNT

RATE_CURRENCY_CODE

RATE_FREQUENCY_CODE

RATE_FREQUENCY_NAME

LEGISLATION_CODE

RATE_SCALE

RATE_ROUNDING_CODE

RATE_ENTERABLE

RATE_FACTOR_ENTERABLE

RATE_BASE_SALARY_FLAG

RATE_OVERALL_SALARY_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

Query

SQL_Statement
SELECT prc.business_group_id, prc.legislative_data_group_id, prc.person_id, prc.work_term_id, csa.assignment_id, prc.assignment_type, csa.salary_id, csa.date_from, csa.date_to, csa.salary_basis_id, csb.name AS salary_basis_name, rdf.rate_definition_id, prc.rate_display_sequence, rdf.name AS rate_name, prc.rate_factor, prc.rate_amount, rdf.fte_flag, prc.rate_annual_amount, prc.rate_annual_ft_amount, rdf.default_rtn_currency AS rate_currency_code, rdf.default_rtn_periodicity AS rate_frequency_code, hlk.meaning AS rate_frequency_name, rdf.legislation_code AS legislation_code, rdf.return_precision AS rate_scale, rdf.return_rounding AS rate_rounding_code, rdf.amount_enterable AS rate_enterable, rdf.factor_enterable AS rate_factor_enterable, rdf.base_salary_flag AS rate_base_salary_flag, rdf.overall_salary_flag AS rate_overall_salary_flag, prc.object_version_number, prc.created_by, prc.creation_date, prc.last_update_date, prc.last_update_login, prc.last_updated_by FROM cmp_salary_pay_components prc, pay_rate_definitions_f_vl rdf, cmp_salary csa, hcm_lookups hlk, cmp_salary_bases csb WHERE prc.pay_rate_definition_id = rdf.rate_definition_id AND csa.salary_id = prc.salary_id AND csa.salary_basis_id = csb.salary_basis_id AND hlk.lookup_type (+) = 'PAY_TMPLT_ET_TIME_DEFINITION' AND hlk.lookup_code (+) = rdf.default_rtn_periodicity AND csa.date_from BETWEEN rdf.effective_start_date AND rdf.effective_end_date ORDER BY csa.assignment_id, csa.salary_id , prc.rate_display_sequence

SQL_Statement

SELECT prc.business_group_id,

prc.legislative_data_group_id,

prc.person_id,

prc.work_term_id,

csa.assignment_id,

prc.assignment_type,

csa.salary_id,

csa.date_from,

csa.date_to,

csa.salary_basis_id,

csb.name AS salary_basis_name,

rdf.rate_definition_id,

prc.rate_display_sequence,

rdf.name AS rate_name,

prc.rate_factor,

prc.rate_amount,

rdf.fte_flag,

prc.rate_annual_amount,

prc.rate_annual_ft_amount,

rdf.default_rtn_currency AS rate_currency_code,

rdf.default_rtn_periodicity AS rate_frequency_code,

hlk.meaning AS rate_frequency_name,

rdf.legislation_code AS legislation_code,

rdf.return_precision AS rate_scale,

rdf.return_rounding AS rate_rounding_code,

rdf.amount_enterable AS rate_enterable,

rdf.factor_enterable AS rate_factor_enterable,

rdf.base_salary_flag AS rate_base_salary_flag,

rdf.overall_salary_flag AS rate_overall_salary_flag,

prc.object_version_number,

prc.created_by,

prc.creation_date,

prc.last_update_date,

prc.last_update_login,

prc.last_updated_by

FROM cmp_salary_pay_components prc,

pay_rate_definitions_f_vl rdf,

cmp_salary csa,

hcm_lookups hlk,

cmp_salary_bases csb

WHERE prc.pay_rate_definition_id = rdf.rate_definition_id

AND csa.salary_id = prc.salary_id

AND csa.salary_basis_id = csb.salary_basis_id

AND hlk.lookup_type (+) = 'PAY_TMPLT_ET_TIME_DEFINITION'

AND hlk.lookup_code (+) = rdf.default_rtn_periodicity

AND csa.date_from BETWEEN rdf.effective_start_date AND rdf.effective_end_date

ORDER BY csa.assignment_id,

csa.salary_id ,

prc.rate_display_sequence