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.

APPS.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_ENTITLEMENTS

Line 219: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel

215: from per_collective_agreements cagr, per_all_assignments_f asg
216: where cagr.status = 'A'
217: and p_params.effective_date >= cagr.start_date
218: and cagr.collective_agreement_id in (select distinct(pce.collective_agreement_id)
219: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel
220: where pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID
221: and pce.STATUS = 'A'
222: and p_params.effective_date between pce.start_date
223: and nvl(pce.end_date,hr_general.end_of_time)

Line 249: from per_cagr_entitlements pce

245: FROM per_collective_agreements cagr, per_all_assignments_f asg
246: WHERE cagr.status = 'A'
247: AND p_params.effective_date >= cagr.start_date
248: AND cagr.collective_agreement_id in (select distinct(pce.collective_agreement_id)
249: from per_cagr_entitlements pce
250: where pce.cagr_entitlement_item_id = p_params.entitlement_item_id
251: and pce.STATUS = 'A'
252: and p_params.effective_date between pce.start_date
253: and nvl(pce.end_date,hr_general.end_of_time)

Line 280: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel

276: AND asg.effective_end_date
277: and asg.COLLECTIVE_AGREEMENT_ID = p_params.COLLECTIVE_AGREEMENT_ID
278: and asg.PRIMARY_FLAG = 'Y')
279: AND exists (select 'x'
280: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel
281: where pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID
282: and pce.STATUS = 'A'
283: and p_params.effective_date between pce.start_date
284: and nvl(pce.end_date,hr_general.end_of_time)

Line 333: per_cagr_entitlements pce,

329: pcel.TO_STEP_ID,
330: pcel.OIPL_ID,
331: pcel.ELIGY_PRFL_ID -- BEN elig profile
332: FROM per_collective_agreements cagr,
333: per_cagr_entitlements pce,
334: per_cagr_entitlement_items pcei,
335: per_cagr_entitlement_lines_f pcel
336: WHERE cagr.COLLECTIVE_AGREEMENT_ID = p_params.collective_agreement_id
337: AND p_params.effective_date BETWEEN cagr.START_DATE

Line 373: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel

369: AND p_params.effective_date BETWEEN cagr.START_DATE
370: AND nvl(cagr.END_DATE, hr_general.end_of_time)
371: AND cagr.STATUS = 'A'
372: AND exists (select 'x'
373: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel
374: where pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID
375: and pce.STATUS = 'A'
376: and p_params.effective_date between pce.start_date
377: and nvl(pce.end_date,hr_general.end_of_time)

Line 424: per_cagr_entitlements pce,

420: pcel.OIPL_ID, -- BEN comp obj
421: pcel.ELIGY_PRFL_ID -- BEN elig profile
422: FROM per_all_assignments_f asg,
423: per_collective_agreements cagr,
424: per_cagr_entitlements pce,
425: per_cagr_entitlement_items pcei,
426: per_cagr_entitlement_lines_f pcel
427: WHERE asg.ASSIGNMENT_ID = p_params.assignment_id
428: AND p_params.effective_date BETWEEN asg.effective_start_date

Line 466: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel

462: AND p_params.effective_date BETWEEN cagr.start_date
463: AND nvl(cagr.end_date, hr_general.end_of_time)
464: AND cagr.status = 'A'
465: AND exists (select 'x'
466: from per_cagr_entitlements pce, per_cagr_entitlement_lines_f pcel
467: where pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID
468: and pce.CAGR_ENTITLEMENT_ITEM_ID = p_params.entitlement_item_id -- only 1 entitlement
469: and pce.STATUS = 'A'
470: and p_params.effective_date between pce.start_date

Line 517: per_cagr_entitlements pce,

513: pcel.OIPL_ID, -- BEN comp obj
514: pcel.ELIGY_PRFL_ID -- BEN elig profile
515: FROM per_all_assignments_f asg,
516: per_collective_agreements cagr,
517: per_cagr_entitlements pce,
518: per_cagr_entitlement_items pcei,
519: per_cagr_entitlement_lines_f pcel
520: WHERE asg.ASSIGNMENT_ID = p_params.assignment_id
521: AND p_params.effective_date BETWEEN asg.effective_start_date

Line 1775: from per_cagr_entitlements pce

1771: where pca.collective_agreement_id = pcrr.collective_agreement_id
1772: and pca.STATUS = 'A'
1773: and p_params.effective_date >= pca.START_DATE)
1774: AND EXISTS (select 'x'
1775: from per_cagr_entitlements pce
1776: where pce.cagr_entitlement_id = pcrr.cagr_entitlement_id
1777: and pce.STATUS = 'A'
1778: and p_params.effective_date between pce.START_DATE and nvl(pce.END_DATE,hr_general.end_of_time))
1779: AND ((pcrr.cagr_entitlement_line_id is not null

Line 1792: FROM per_cagr_entitlements pce

1788: -- Cursor to return entitlement values (status and date are done checked driving cursor above)
1789: --
1790: CURSOR csr_cagr_ents (v_ent_id in NUMBER) IS
1791: SELECT *
1792: FROM per_cagr_entitlements pce
1793: WHERE pce.CAGR_ENTITLEMENT_ID = v_ent_id;
1794: --
1795: -- Cursor to return active entitlement line values on the effective_date.
1796: -- (status and date are done checked driving cursor above)

Line 2118: from per_cagr_entitlements pce

2114: where pca.collective_agreement_id = pcrr.collective_agreement_id
2115: and pca.STATUS = 'A'
2116: and p_params.effective_date >= pca.START_DATE)
2117: AND EXISTS (select 'x'
2118: from per_cagr_entitlements pce
2119: where pce.cagr_entitlement_id = pcrr.cagr_entitlement_id
2120: and pce.STATUS = 'A'
2121: and p_params.effective_date BETWEEN pce.START_DATE
2122: AND nvl(pce.END_DATE,hr_general.end_of_time))

Line 2138: FROM per_cagr_entitlements pce

2134: -- Cursor to return entitlement values (driving cursor checks date and status)
2135: --
2136: CURSOR csr_cagr_ents (v_ent_id in NUMBER) IS
2137: SELECT *
2138: FROM per_cagr_entitlements pce
2139: WHERE pce.CAGR_ENTITLEMENT_ID = v_ent_id
2140: AND p_params.effective_date BETWEEN pce.START_DATE
2141: AND nvl(pce.END_DATE,hr_general.end_of_time);
2142: --