VIEW: APPS.HRFV_SALARY_COMPONENTS

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,peo.full_name person_name ,hr_bis.bis_decode_lookup('PROPOSAL_REASON',pcomp.component_reason) salary_change_reason ,asg.assignment_number assignment_number ,hr_bis.bis_decode_lookup('YES_NO',pcomp.approved) approved_flag ,pcomp.change_amount_n salary_change_amount ,pcomp.change_percentage salary_change_percentage ,peo.employee_number employee_number ,pro.change_date salary_change_date ,hr_bis.bis_decode_lookup('YES_NO', DECODE(peo.current_employee_flag,null,'N','Y')) current_employee_flag ,'_DF:PER:PER_PAY_PROPOSAL_COMPONENTS:pcomp' ,asg.assignment_id assignment_id ,asg.business_group_id business_group_id ,pcomp.pay_proposal_id pay_proposal_id ,peo.person_id person_id ,pcomp.component_id salary_component_id FROM per_pay_proposal_components pcomp ,hr_all_organization_units_tl bgrT ,per_people_x peo ,per_pay_proposals pro ,per_all_assignments_f asg WHERE asg.person_id = peo.person_id AND pro.change_date BETWEEN peo.effective_start_date AND peo.effective_end_date AND pro.assignment_id = asg.assignment_id AND pro.pay_proposal_id = pcomp.pay_proposal_id AND pro.change_date BETWEEN asg.effective_start_date AND asg.effective_end_date AND asg.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND asg.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,asg.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PEO.FULL_NAME PERSON_NAME
, HR_BIS.BIS_DECODE_LOOKUP('PROPOSAL_REASON'
, PCOMP.COMPONENT_REASON) SALARY_CHANGE_REASON
, ASG.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PCOMP.APPROVED) APPROVED_FLAG
, PCOMP.CHANGE_AMOUNT_N SALARY_CHANGE_AMOUNT
, PCOMP.CHANGE_PERCENTAGE SALARY_CHANGE_PERCENTAGE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PRO.CHANGE_DATE SALARY_CHANGE_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, DECODE(PEO.CURRENT_EMPLOYEE_FLAG
, NULL
, 'N'
, 'Y')) CURRENT_EMPLOYEE_FLAG
, '_DF:PER:PER_PAY_PROPOSAL_COMPONENTS:PCOMP'
, ASG.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PCOMP.PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, PEO.PERSON_ID PERSON_ID
, PCOMP.COMPONENT_ID SALARY_COMPONENT_ID
FROM PER_PAY_PROPOSAL_COMPONENTS PCOMP
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PER_PEOPLE_X PEO
, PER_PAY_PROPOSALS PRO
, PER_ALL_ASSIGNMENTS_F ASG
WHERE ASG.PERSON_ID = PEO.PERSON_ID
AND PRO.CHANGE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND PRO.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PRO.PAY_PROPOSAL_ID = PCOMP.PAY_PROPOSAL_ID
AND PRO.CHANGE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND ASG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ASG.BUSINESS_GROUP_ID) WITH READ ONLY