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 HR_GENERAL

Line 155: AND p_process_date between res.start_date and nvl(res.end_date, hr_general.end_of_time)

151: WHERE asg.assignment_id = res.assignment_id
152: AND asg.primary_flag = 'Y'
153: AND p_process_date between asg.effective_start_date and asg.effective_end_date
154: AND res.cagr_entitlement_item_id = p_entitlement_item_id
155: AND p_process_date between res.start_date and nvl(res.end_date, hr_general.end_of_time)
156: AND (p_collective_agreement_id is null or asg.collective_agreement_id = p_collective_agreement_id)
157: AND (p_value is null or res.value = p_value)
158: AND (p_step_id is null or res.step_id = p_step_id)
159: order by asg.PERSON_ID;

Line 223: and nvl(pce.end_date,hr_general.end_of_time)

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)
224: and pcel.STATUS = 'A'
225: and pcel.OIPL_ID <> 0 and pcel.ELIGY_PRFL_ID <> 0
226: and p_params.effective_date between pcel.effective_start_date
227: and pcel.effective_end_date

Line 253: and nvl(pce.end_date,hr_general.end_of_time)

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)
254: and (p_params.collective_agreement_id is null or
255: pce.collective_agreement_id = p_params.collective_agreement_id))
256: AND cagr.collective_agreement_id = asg.collective_agreement_id
257: AND asg.PRIMARY_FLAG = 'Y'

Line 271: AND nvl(cagr.END_DATE, hr_general.end_of_time)

267: SELECT pl_id
268: FROM per_collective_agreements cagr
269: WHERE cagr.COLLECTIVE_AGREEMENT_ID = p_params.COLLECTIVE_AGREEMENT_ID
270: AND p_params.effective_date BETWEEN cagr.START_DATE
271: AND nvl(cagr.END_DATE, hr_general.end_of_time)
272: AND cagr.STATUS = 'A'
273: AND exists (select 'x'
274: from per_all_assignments_f asg
275: where p_params.effective_date BETWEEN asg.effective_start_date

Line 284: and nvl(pce.end_date,hr_general.end_of_time)

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)
285: and pcel.STATUS = 'A'
286: and pcel.OIPL_ID <> 0 and pcel.ELIGY_PRFL_ID <> 0
287: and p_params.effective_date between pcel.effective_start_date and pcel.effective_end_date
288: and pce.collective_agreement_id = p_params.COLLECTIVE_AGREEMENT_ID);

Line 338: AND nvl(cagr.END_DATE, hr_general.end_of_time)

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
338: AND nvl(cagr.END_DATE, hr_general.end_of_time)
339: AND cagr.STATUS = 'A'
340: AND cagr.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
341: AND pce.STATUS = 'A'
342: AND p_params.effective_date BETWEEN pce.START_DATE

Line 343: AND nvl(pce.END_DATE,hr_general.end_of_time)

339: AND cagr.STATUS = 'A'
340: AND cagr.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
341: AND pce.STATUS = 'A'
342: AND p_params.effective_date BETWEEN pce.START_DATE
343: AND nvl(pce.END_DATE,hr_general.end_of_time)
344: AND pce.CAGR_ENTITLEMENT_ITEM_ID = pcei.CAGR_ENTITLEMENT_ITEM_ID
345: AND pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID (+)
346: AND ((pcel.CAGR_ENTITLEMENT_ID IS NOT NULL
347: AND p_params.effective_date BETWEEN pcel.effective_start_date

Line 370: AND nvl(cagr.END_DATE, hr_general.end_of_time)

366: AND asg.effective_end_date
367: AND asg.PRIMARY_FLAG = 'Y'
368: AND asg.COLLECTIVE_AGREEMENT_ID = cagr.COLLECTIVE_AGREEMENT_ID
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

Line 377: and nvl(pce.end_date,hr_general.end_of_time)

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)
378: and pcel.STATUS = 'A'
379: and pcel.OIPL_ID <> 0 and pcel.ELIGY_PRFL_ID <> 0
380: and p_params.effective_date between pcel.effective_start_date and pcel.effective_end_date
381: and pce.collective_agreement_id = asg.COLLECTIVE_AGREEMENT_ID);

Line 433: AND nvl(cagr.END_DATE, hr_general.end_of_time)

429: AND asg.effective_end_date
430: AND asg.PRIMARY_FLAG = 'Y'
431: AND asg.COLLECTIVE_AGREEMENT_ID = cagr.COLLECTIVE_AGREEMENT_ID
432: AND p_params.effective_date BETWEEN cagr.START_DATE
433: AND nvl(cagr.END_DATE, hr_general.end_of_time)
434: AND cagr.STATUS = 'A'
435: AND asg.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
436: AND pce.STATUS = 'A'
437: AND p_params.effective_date BETWEEN pce.START_DATE

Line 438: AND nvl(pce.END_DATE,hr_general.end_of_time)

434: AND cagr.STATUS = 'A'
435: AND asg.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
436: AND pce.STATUS = 'A'
437: AND p_params.effective_date BETWEEN pce.START_DATE
438: AND nvl(pce.END_DATE,hr_general.end_of_time)
439: AND pce.CAGR_ENTITLEMENT_ITEM_ID = pcei.CAGR_ENTITLEMENT_ITEM_ID
440: AND pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID (+)
441: AND ((pcel.CAGR_ENTITLEMENT_ID IS NOT NULL
442: AND p_params.effective_date BETWEEN pcel.effective_start_date

Line 463: AND nvl(cagr.end_date, hr_general.end_of_time)

459: AND asg.effective_end_date
460: AND asg.PRIMARY_FLAG = 'Y'
461: AND asg.collective_agreement_id = cagr.collective_agreement_id
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

Line 471: and nvl(pce.end_date,hr_general.end_of_time)

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
471: and nvl(pce.end_date,hr_general.end_of_time)
472: and pcel.STATUS = 'A'
473: and pcel.OIPL_ID <> 0 and pcel.ELIGY_PRFL_ID <> 0 -- ignore default elig lines
474: and p_params.effective_date between pcel.effective_start_date
475: and pcel.effective_end_date);

Line 526: AND nvl(cagr.END_DATE, hr_general.end_of_time)

522: AND asg.effective_end_date
523: AND asg.PRIMARY_FLAG = 'Y'
524: AND asg.COLLECTIVE_AGREEMENT_ID = cagr.COLLECTIVE_AGREEMENT_ID
525: AND p_params.effective_date BETWEEN cagr.START_DATE
526: AND nvl(cagr.END_DATE, hr_general.end_of_time)
527: AND cagr.STATUS = 'A'
528: AND asg.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
529: AND pce.STATUS = 'A'
530: AND pce.CAGR_ENTITLEMENT_ITEM_ID = p_params.entitlement_item_id -- only 1 entitlement

Line 532: AND nvl(pce.END_DATE,hr_general.end_of_time)

528: AND asg.COLLECTIVE_AGREEMENT_ID = pce.COLLECTIVE_AGREEMENT_ID
529: AND pce.STATUS = 'A'
530: AND pce.CAGR_ENTITLEMENT_ITEM_ID = p_params.entitlement_item_id -- only 1 entitlement
531: AND p_params.effective_date BETWEEN pce.START_DATE
532: AND nvl(pce.END_DATE,hr_general.end_of_time)
533: AND pce.CAGR_ENTITLEMENT_ITEM_ID = pcei.CAGR_ENTITLEMENT_ITEM_ID
534: AND pce.CAGR_ENTITLEMENT_ID = pcel.CAGR_ENTITLEMENT_ID (+)
535: AND ((pcel.CAGR_ENTITLEMENT_ID IS NOT NULL
536: AND p_params.effective_date BETWEEN pcel.effective_start_date

Line 620: AND p_effective_date between res.START_DATE and nvl(res.END_DATE, hr_general.end_of_time)

616: parent_spine_id,
617: step_id
618: FROM per_cagr_entitlement_results res
619: WHERE res.assignment_id = p_assignment_id
620: AND p_effective_date between res.START_DATE and nvl(res.END_DATE, hr_general.end_of_time)
621: AND chosen_flag = 'Y';
622:
623: l_proc constant VARCHAR2(81) := g_pkg || '.store_chosen_results';
624: t_chosen_table chosen_table;

Line 747: AND nvl(erl.END_DATE,hr_general.end_of_time);

743: WHERE erl.ASSIGNMENT_ID = p_assignment_id
744: AND erl.COLLECTIVE_AGREEMENT_ID = p_cagr_id
745: AND erl.CAGR_ENTITLEMENT_ITEM_ID = p_entitlement_item_id
746: AND p_effective_date BETWEEN erl.START_DATE
747: AND nvl(erl.END_DATE,hr_general.end_of_time);
748:
749: l_rec cagr_SE_record;
750: l_beneficial_flag per_cagr_entitlement_results.beneficial_flag%TYPE;
751: l_no_results BOOLEAN := TRUE;

Line 1026: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)

1022: CURSOR csr_all_results (v_assignment_id in number) IS
1023: SELECT er.start_date, er.cagr_request_id, er.element_type_id
1024: FROM per_cagr_entitlement_results er
1025: WHERE er.assignment_id = v_assignment_id
1026: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1027: ORDER BY er.cagr_request_id
1028: FOR UPDATE OF END_DATE NOWAIT;
1029:
1030: -- update all results for a specific item found in cache

Line 1037: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)

1033: SELECT er.start_date, er.cagr_request_id
1034: FROM per_cagr_entitlement_results er
1035: WHERE er.assignment_id = p_params.assignment_id
1036: AND er.cagr_entitlement_item_id = p_params.entitlement_item_id
1037: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1038: FOR UPDATE OF END_DATE NOWAIT;
1039:
1040: -- test if any future result(s) exists for the item and asg
1041: -- and return the start_date of earliest future result set

Line 1768: AND p_params.effective_date BETWEEN pcrr.START_DATE AND nvl(pcrr.END_DATE,hr_general.end_of_time)

1764: CURSOR csr_cagr_retained_rights IS
1765: SELECT * from per_cagr_retained_rights pcrr
1766: WHERE pcrr.assignment_id = p_assignment_id
1767: AND cagr_entitlement_item_id = p_cagr_entitlement_item_id
1768: AND p_params.effective_date BETWEEN pcrr.START_DATE AND nvl(pcrr.END_DATE,hr_general.end_of_time)
1769: AND EXISTS (select 'x'
1770: from per_collective_agreements pca
1771: where pca.collective_agreement_id = pcrr.collective_agreement_id
1772: and pca.STATUS = 'A'

Line 1778: and p_params.effective_date between pce.START_DATE and nvl(pce.END_DATE,hr_general.end_of_time))

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
1780: and EXISTS (select 'x'
1781: from per_cagr_entitlement_lines_f pcel
1782: where pcel.cagr_entitlement_line_id = pcrr.cagr_entitlement_line_id

Line 1804: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);

1800: SELECT *
1801: FROM per_cagr_entitlement_lines_f pcel
1802: WHERE pcel.CAGR_ENTITLEMENT_LINE_ID = v_line_id
1803: AND p_effective_date BETWEEN pcel.EFFECTIVE_START_DATE
1804: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);
1805: --
1806: -- Cursor to return entitlement line values on the effective_date
1807: --
1808: v_csr_rr_rec csr_cagr_retained_rights%ROWTYPE;

Line 2106: AND nvl(pcrr.END_DATE,hr_general.end_of_time)

2102: SELECT *
2103: FROM per_cagr_retained_rights pcrr
2104: WHERE pcrr.assignment_id = p_params.assignment_id
2105: AND p_params.effective_date BETWEEN pcrr.START_DATE
2106: AND nvl(pcrr.END_DATE,hr_general.end_of_time)
2107: AND EXISTS (select 'X' from per_all_assignments_f asg
2108: where asg.assignment_id = p_params.assignment_id
2109: and p_params.effective_date BETWEEN asg.effective_start_date
2110: AND asg.effective_end_date

Line 2122: AND nvl(pce.END_DATE,hr_general.end_of_time))

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))
2123: AND ((pcrr.cagr_entitlement_line_id is not null
2124: and EXISTS (select 'x'
2125: from per_cagr_entitlement_lines_f pcel
2126: where pcel.cagr_entitlement_line_id = pcrr.cagr_entitlement_line_id

Line 2141: AND nvl(pce.END_DATE,hr_general.end_of_time);

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: --
2143: -- Cursor to return active entitlement line values on the effective_date
2144: --
2145: CURSOR csr_cagr_lines (v_line_id in NUMBER, v_cagr_id IN NUMBER) IS

Line 2150: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);

2146: SELECT *
2147: FROM per_cagr_entitlement_lines_f pcel
2148: WHERE pcel.CAGR_ENTITLEMENT_LINE_ID = v_line_id
2149: AND p_params.effective_date BETWEEN pcel.EFFECTIVE_START_DATE
2150: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);
2151: --
2152: -- Cursor to get the beneficial rule info for specific entitlement_item
2153: --
2154: cursor csr_ben_rule (l_cagr_entitlement_item_id IN NUMBER) is