VIEW: APPS.HRI_MD_SALARY_CMPNT_H_V

Source

View Text - Preformatted

SELECT scp.annualized_cmpnt_change annualized_cmpnt_change , scp.total_change annualized_total_change , scp.cmpnt_change cmpnt_change , scp.total_change total_change , scp.cmpnt_of_ttl_change_prcnt cmpnt_of_ttl_change_prcnt , scp.cmpnt_of_prev_sal_prcnt cmpnt_of_prev_sal_prcnt , scp.annualized_salary annualized_salary , scp.prev_annualized_salary prev_annualized_salary , scp.salary salary , scp.salary_change salary_change , scp.annualization_factor annualization_factor , scp.days_from_last_change days_from_last_change , scp.event_date event_date , scp.prev_event_date prev_event_date , scp.assignment_id assignment_id , scp.person_id person_id , scp.business_group_id business_group_id , scp.organization_id organization_id , scp.location_id location_id , scp.job_id job_id , scp.grade_id grade_id , scp.position_id position_id , scp.supervisor_person_id supervisor_person_id , scp.pay_proposal_id pay_proposal_id , scp.currency_code currency_code , scp.output_currency_code output_currency_code , scp.perf_rating_code perf_rating_code , scp.multiple_cmpnt_flag_code multiple_cmpnt_flag_code , scp.salary_change_reason_code salary_change_reason_code , scp.salary_cmpnt_reason_code salary_cmpnt_reason_code , scp.last_salary_flag_code last_salary_flag_code , scp.last_change_date last_change_date , scp.asg_last_update_date asg_last_update_date , scp.pro_last_update_date pro_last_update_date FROM hri_md_salary_cmpnt_v scp WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE' , HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F' , scp.assignment_id , scp.person_id , scp.assignment_type_code ) ) = 'TRUE' WITH READ ONLY

View Text - HTML Formatted

SELECT SCP.ANNUALIZED_CMPNT_CHANGE ANNUALIZED_CMPNT_CHANGE
, SCP.TOTAL_CHANGE ANNUALIZED_TOTAL_CHANGE
, SCP.CMPNT_CHANGE CMPNT_CHANGE
, SCP.TOTAL_CHANGE TOTAL_CHANGE
, SCP.CMPNT_OF_TTL_CHANGE_PRCNT CMPNT_OF_TTL_CHANGE_PRCNT
, SCP.CMPNT_OF_PREV_SAL_PRCNT CMPNT_OF_PREV_SAL_PRCNT
, SCP.ANNUALIZED_SALARY ANNUALIZED_SALARY
, SCP.PREV_ANNUALIZED_SALARY PREV_ANNUALIZED_SALARY
, SCP.SALARY SALARY
, SCP.SALARY_CHANGE SALARY_CHANGE
, SCP.ANNUALIZATION_FACTOR ANNUALIZATION_FACTOR
, SCP.DAYS_FROM_LAST_CHANGE DAYS_FROM_LAST_CHANGE
, SCP.EVENT_DATE EVENT_DATE
, SCP.PREV_EVENT_DATE PREV_EVENT_DATE
, SCP.ASSIGNMENT_ID ASSIGNMENT_ID
, SCP.PERSON_ID PERSON_ID
, SCP.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, SCP.ORGANIZATION_ID ORGANIZATION_ID
, SCP.LOCATION_ID LOCATION_ID
, SCP.JOB_ID JOB_ID
, SCP.GRADE_ID GRADE_ID
, SCP.POSITION_ID POSITION_ID
, SCP.SUPERVISOR_PERSON_ID SUPERVISOR_PERSON_ID
, SCP.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, SCP.CURRENCY_CODE CURRENCY_CODE
, SCP.OUTPUT_CURRENCY_CODE OUTPUT_CURRENCY_CODE
, SCP.PERF_RATING_CODE PERF_RATING_CODE
, SCP.MULTIPLE_CMPNT_FLAG_CODE MULTIPLE_CMPNT_FLAG_CODE
, SCP.SALARY_CHANGE_REASON_CODE SALARY_CHANGE_REASON_CODE
, SCP.SALARY_CMPNT_REASON_CODE SALARY_CMPNT_REASON_CODE
, SCP.LAST_SALARY_FLAG_CODE LAST_SALARY_FLAG_CODE
, SCP.LAST_CHANGE_DATE LAST_CHANGE_DATE
, SCP.ASG_LAST_UPDATE_DATE ASG_LAST_UPDATE_DATE
, SCP.PRO_LAST_UPDATE_DATE PRO_LAST_UPDATE_DATE
FROM HRI_MD_SALARY_CMPNT_V SCP
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F'
, SCP.ASSIGNMENT_ID
, SCP.PERSON_ID
, SCP.ASSIGNMENT_TYPE_CODE ) ) = 'TRUE' WITH READ ONLY