VIEW: APPS.PQH_FR_CAGR_ENTITLEMENTS_V

Source

View Text - Preformatted

SELECT pcer.cagr_entitlement_item_id CAGR_ENTITLEMENT_ITEM_ID, pcei.item_name ITEM_NAME, pcer.business_group_id BUSINESS_GROUP_ID, pcer.value VALUE, pcer.range_from RANGE_FROM, pcer.range_to RANGE_TO, pcer.start_date ENTITL_START_DATE, pcer.end_date ENTITL_END_DATE, asg.effective_start_date ASG_START_DATE, asg.effective_end_date ASG_END_DATE, per.effective_start_date PER_START_DATE, per.effective_end_date PER_END_DATE, per.person_id PERSON_ID, per.employee_number EMPLOYEE_NUMBER, per.last_name LAST_NAME, per.first_name FIRST_NAME, per.full_name FULL_NAME, pcer.assignment_id ASSIGNMENT_ID, asg.organization_id ORGANIZATION_ID, hr_general.decode_organization(asg.organization_id) ORGANIZATION_NAME, asg.establishment_id ESTABLISHMENT_ID, hr_general.decode_organization(asg.establishment_id) ESTABLISHMENT_NAME, asg.job_id JOB_ID, hr_general.decode_job(asg.job_id) JOB_NAME, asg.position_id POSITION_ID, hr_general.decode_position_latest_name(asg.position_id) POSITION_NAME, asg.grade_id GRADE_ID, hr_general.decode_grade(asg.grade_id) GRADE_NAME, asg.location_id LOCATION_ID, hr_general.decode_location(asg.location_id) LOCATION_NAME from per_cagr_entitlement_results pcer, per_cagr_entitlement_items pcei, per_all_assignments_f asg, per_all_people_f per WHERE pcer.cagr_entitlement_item_id = pcei.cagr_entitlement_item_id AND pcer.assignment_id = asg.assignment_id AND asg.person_id = per.person_id

View Text - HTML Formatted

SELECT PCER.CAGR_ENTITLEMENT_ITEM_ID CAGR_ENTITLEMENT_ITEM_ID
, PCEI.ITEM_NAME ITEM_NAME
, PCER.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PCER.VALUE VALUE
, PCER.RANGE_FROM RANGE_FROM
, PCER.RANGE_TO RANGE_TO
, PCER.START_DATE ENTITL_START_DATE
, PCER.END_DATE ENTITL_END_DATE
, ASG.EFFECTIVE_START_DATE ASG_START_DATE
, ASG.EFFECTIVE_END_DATE ASG_END_DATE
, PER.EFFECTIVE_START_DATE PER_START_DATE
, PER.EFFECTIVE_END_DATE PER_END_DATE
, PER.PERSON_ID PERSON_ID
, PER.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PER.LAST_NAME LAST_NAME
, PER.FIRST_NAME FIRST_NAME
, PER.FULL_NAME FULL_NAME
, PCER.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.ORGANIZATION_ID ORGANIZATION_ID
, HR_GENERAL.DECODE_ORGANIZATION(ASG.ORGANIZATION_ID) ORGANIZATION_NAME
, ASG.ESTABLISHMENT_ID ESTABLISHMENT_ID
, HR_GENERAL.DECODE_ORGANIZATION(ASG.ESTABLISHMENT_ID) ESTABLISHMENT_NAME
, ASG.JOB_ID JOB_ID
, HR_GENERAL.DECODE_JOB(ASG.JOB_ID) JOB_NAME
, ASG.POSITION_ID POSITION_ID
, HR_GENERAL.DECODE_POSITION_LATEST_NAME(ASG.POSITION_ID) POSITION_NAME
, ASG.GRADE_ID GRADE_ID
, HR_GENERAL.DECODE_GRADE(ASG.GRADE_ID) GRADE_NAME
, ASG.LOCATION_ID LOCATION_ID
, HR_GENERAL.DECODE_LOCATION(ASG.LOCATION_ID) LOCATION_NAME
FROM PER_CAGR_ENTITLEMENT_RESULTS PCER
, PER_CAGR_ENTITLEMENT_ITEMS PCEI
, PER_ALL_ASSIGNMENTS_F ASG
, PER_ALL_PEOPLE_F PER
WHERE PCER.CAGR_ENTITLEMENT_ITEM_ID = PCEI.CAGR_ENTITLEMENT_ITEM_ID
AND PCER.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND ASG.PERSON_ID = PER.PERSON_ID