VIEW: APPS.HRI_MD_SALARY_CMPNT_V

Source

View Text - Preformatted

SELECT sct.cmpnt_change annualized_cmpnt_change , sct.total_change annualized_total_change , sct.cmpnt_change cmpnt_change , sct.total_change total_change , sct.cmpnt_of_ttl_change_prcnt cmpnt_of_ttl_change_prcnt , sct.cmpnt_of_prev_sal_prcnt cmpnt_of_prev_sal_prcnt , scg.annualized_salary annualized_salary , scg.prev_annualized_salary prev_annualized_salary , scg.salary salary , scg.salary_change salary_change , scg.annualization_factor annualization_factor , scg.days_from_last_change days_from_last_change , scg.event_date event_date , scg.prev_event_date prev_event_date , scg.assignment_id assignment_id , scg.person_id person_id , scg.business_group_id business_group_id , scg.organization_id organization_id , scg.location_id location_id , scg.job_id job_id , scg.grade_id grade_id , scg.position_id position_id , scg.supervisor_person_id supervisor_person_id , scg.assignment_type_code assignment_type_code , scg.pay_proposal_id pay_proposal_id , scg.currency_code currency_code , scg.output_currency_code output_currency_code , scg.perf_rating_code perf_rating_code , scg.multiple_cmpnt_flag_code multiple_cmpnt_flag_code , scg.salary_change_reason_code salary_change_reason_code , sct.salary_cmpnt_reason_code salary_cmpnt_reason_code , scg.last_salary_flag_code last_salary_flag_code , GREATEST(sct.last_change_date ,scg.last_change_date) last_change_date , scg.asg_last_update_date asg_last_update_date , scg.pro_last_update_date pro_last_update_date FROM hri_cs_salary_cmpnt_v sct , hri_mb_salary_change_v scg WHERE sct.pay_proposal_id = scg.pay_proposal_id AND sct.event_date = scg.event_date WITH READ ONLY

View Text - HTML Formatted

SELECT SCT.CMPNT_CHANGE ANNUALIZED_CMPNT_CHANGE
, SCT.TOTAL_CHANGE ANNUALIZED_TOTAL_CHANGE
, SCT.CMPNT_CHANGE CMPNT_CHANGE
, SCT.TOTAL_CHANGE TOTAL_CHANGE
, SCT.CMPNT_OF_TTL_CHANGE_PRCNT CMPNT_OF_TTL_CHANGE_PRCNT
, SCT.CMPNT_OF_PREV_SAL_PRCNT CMPNT_OF_PREV_SAL_PRCNT
, SCG.ANNUALIZED_SALARY ANNUALIZED_SALARY
, SCG.PREV_ANNUALIZED_SALARY PREV_ANNUALIZED_SALARY
, SCG.SALARY SALARY
, SCG.SALARY_CHANGE SALARY_CHANGE
, SCG.ANNUALIZATION_FACTOR ANNUALIZATION_FACTOR
, SCG.DAYS_FROM_LAST_CHANGE DAYS_FROM_LAST_CHANGE
, SCG.EVENT_DATE EVENT_DATE
, SCG.PREV_EVENT_DATE PREV_EVENT_DATE
, SCG.ASSIGNMENT_ID ASSIGNMENT_ID
, SCG.PERSON_ID PERSON_ID
, SCG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SCG.ORGANIZATION_ID ORGANIZATION_ID
, SCG.LOCATION_ID LOCATION_ID
, SCG.JOB_ID JOB_ID
, SCG.GRADE_ID GRADE_ID
, SCG.POSITION_ID POSITION_ID
, SCG.SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, SCG.ASSIGNMENT_TYPE_CODE ASSIGNMENT_TYPE_CODE
, SCG.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, SCG.CURRENCY_CODE CURRENCY_CODE
, SCG.OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE
, SCG.PERF_RATING_CODE PERF_RATING_CODE
, SCG.MULTIPLE_CMPNT_FLAG_CODE MULTIPLE_CMPNT_FLAG_CODE
, SCG.SALARY_CHANGE_REASON_CODE SALARY_CHANGE_REASON_CODE
, SCT.SALARY_CMPNT_REASON_CODE SALARY_CMPNT_REASON_CODE
, SCG.LAST_SALARY_FLAG_CODE LAST_SALARY_FLAG_CODE
, GREATEST(SCT.LAST_CHANGE_DATE
, SCG.LAST_CHANGE_DATE) LAST_CHANGE_DATE
, SCG.ASG_LAST_UPDATE_DATE ASG_LAST_UPDATE_DATE
, SCG.PRO_LAST_UPDATE_DATE PRO_LAST_UPDATE_DATE
FROM HRI_CS_SALARY_CMPNT_V SCT
, HRI_MB_SALARY_CHANGE_V SCG
WHERE SCT.PAY_PROPOSAL_ID = SCG.PAY_PROPOSAL_ID
AND SCT.EVENT_DATE = SCG.EVENT_DATE WITH READ ONLY