View: PQH_FR_CAGR_ENTITLEMENTS_V

Product:	PQH - Public Sector HR
Description:	French Public Sector - Collective Agreements Entitlements view
Implementation/DBA Data:	APPS.PQH_FR_CAGR_ENTITLEMENTS_V

View Text

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

Columns