eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_CAGR_ENTITLEMENTS_V2

Source

View Text - Preformatted


SELECT ent.ASSIGNMENT_ID ,ent.CAGR_ENTITLEMENT_ITEM_ID ,ent.ITEM_NAME ,ent.CATEGORY_NAME ,SUBSTR(hr_general.decode_lookup('CAGR_CATEGORIES', ent.CATEGORY_NAME), 1, 80) FROM ((select en.cagr_entitlement_item_id, ei.ITEM_NAME ,asg.assignment_id, ei.CATEGORY_NAME from per_cagr_entitlements en, per_collective_agreements ca, per_all_assignments_f asg, per_cagr_entitlement_items ei, fnd_sessions ses where en.status = 'A' and ses.session_id = USERENV('SESSIONID') and ses.EFFECTIVE_DATE between en.START_DATE AND nvl(en.END_DATE,hr_general.end_of_time) and en.COLLECTIVE_AGREEMENT_ID = ca.COLLECTIVE_AGREEMENT_ID and ses.EFFECTIVE_DATE >= ca.START_DATE and ca.STATUS = 'A' and en.COLLECTIVE_AGREEMENT_ID = asg.COLLECTIVE_AGREEMENT_ID and ses.EFFECTIVE_DATE between asg.EFFECTIVE_START_DATE AND asg.EFFECTIVE_END_DATE and en.CAGR_ENTITLEMENT_ITEM_ID = ei.CAGR_ENTITLEMENT_ITEM_ID) union (select rr.cagr_entitlement_item_id, items.ITEM_NAME ,rr.assignment_id, items.CATEGORY_NAME from per_cagr_retained_rights rr, per_cagr_entitlements ents, per_collective_agreements cagr, per_cagr_entitlement_items items, fnd_sessions sess where sess.session_id = USERENV('SESSIONID') and sess.EFFECTIVE_DATE between rr.START_DATE and nvl(rr.END_DATE,hr_general.end_of_time) and rr.COLLECTIVE_AGREEMENT_ID = cagr.COLLECTIVE_AGREEMENT_ID and sess.EFFECTIVE_DATE >= cagr.START_DATE and cagr.STATUS = 'A' and rr.CAGR_ENTITLEMENT_ID = ents.CAGR_ENTITLEMENT_ID and ents.STATUS = 'A' and sess.EFFECTIVE_DATE between ents.START_DATE AND nvl(ents.END_DATE,hr_general.end_of_time) and rr.CAGR_ENTITLEMENT_ITEM_ID = items.CAGR_ENTITLEMENT_ITEM_ID)) ent ORDER BY ITEM_NAME

View Text - HTML Formatted

SELECT ENT.ASSIGNMENT_ID
, ENT.CAGR_ENTITLEMENT_ITEM_ID
, ENT.ITEM_NAME
, ENT.CATEGORY_NAME
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('CAGR_CATEGORIES'
, ENT.CATEGORY_NAME)
, 1
, 80)
FROM ((SELECT EN.CAGR_ENTITLEMENT_ITEM_ID
, EI.ITEM_NAME
, ASG.ASSIGNMENT_ID
, EI.CATEGORY_NAME
FROM PER_CAGR_ENTITLEMENTS EN
, PER_COLLECTIVE_AGREEMENTS CA
, PER_ALL_ASSIGNMENTS_F ASG
, PER_CAGR_ENTITLEMENT_ITEMS EI
, FND_SESSIONS SES
WHERE EN.STATUS = 'A'
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN EN.START_DATE
AND NVL(EN.END_DATE
, HR_GENERAL.END_OF_TIME)
AND EN.COLLECTIVE_AGREEMENT_ID = CA.COLLECTIVE_AGREEMENT_ID
AND SES.EFFECTIVE_DATE >= CA.START_DATE
AND CA.STATUS = 'A'
AND EN.COLLECTIVE_AGREEMENT_ID = ASG.COLLECTIVE_AGREEMENT_ID
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND EN.CAGR_ENTITLEMENT_ITEM_ID = EI.CAGR_ENTITLEMENT_ITEM_ID) UNION (SELECT RR.CAGR_ENTITLEMENT_ITEM_ID
, ITEMS.ITEM_NAME
, RR.ASSIGNMENT_ID
, ITEMS.CATEGORY_NAME
FROM PER_CAGR_RETAINED_RIGHTS RR
, PER_CAGR_ENTITLEMENTS ENTS
, PER_COLLECTIVE_AGREEMENTS CAGR
, PER_CAGR_ENTITLEMENT_ITEMS ITEMS
, FND_SESSIONS SESS
WHERE SESS.SESSION_ID = USERENV('SESSIONID')
AND SESS.EFFECTIVE_DATE BETWEEN RR.START_DATE
AND NVL(RR.END_DATE
, HR_GENERAL.END_OF_TIME)
AND RR.COLLECTIVE_AGREEMENT_ID = CAGR.COLLECTIVE_AGREEMENT_ID
AND SESS.EFFECTIVE_DATE >= CAGR.START_DATE
AND CAGR.STATUS = 'A'
AND RR.CAGR_ENTITLEMENT_ID = ENTS.CAGR_ENTITLEMENT_ID
AND ENTS.STATUS = 'A'
AND SESS.EFFECTIVE_DATE BETWEEN ENTS.START_DATE
AND NVL(ENTS.END_DATE
, HR_GENERAL.END_OF_TIME)
AND RR.CAGR_ENTITLEMENT_ITEM_ID = ITEMS.CAGR_ENTITLEMENT_ITEM_ID)) ENT ORDER BY ITEM_NAME