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 1008: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)

1004: CURSOR csr_all_results (v_assignment_id in number) IS
1005: SELECT er.start_date, er.cagr_request_id
1006: FROM per_cagr_entitlement_results er
1007: WHERE er.assignment_id = v_assignment_id
1008: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1009: ORDER BY er.cagr_request_id
1010: FOR UPDATE OF END_DATE NOWAIT;
1011:
1012: -- update all results for a specific item found in cache

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

1015: SELECT er.start_date, er.cagr_request_id
1016: FROM per_cagr_entitlement_results er
1017: WHERE er.assignment_id = p_params.assignment_id
1018: AND er.cagr_entitlement_item_id = p_params.entitlement_item_id
1019: AND p_params.effective_date BETWEEN er.START_DATE AND nvl(er.END_DATE,hr_general.END_OF_TIME)
1020: FOR UPDATE OF END_DATE NOWAIT;
1021:
1022: -- test if any future result(s) exists for the item and asg
1023: -- and return the start_date of earliest future result set

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

1692: CURSOR csr_cagr_retained_rights IS
1693: SELECT * from per_cagr_retained_rights pcrr
1694: WHERE pcrr.assignment_id = p_assignment_id
1695: AND cagr_entitlement_item_id = p_cagr_entitlement_item_id
1696: AND p_params.effective_date BETWEEN pcrr.START_DATE AND nvl(pcrr.END_DATE,hr_general.end_of_time)
1697: AND EXISTS (select 'x'
1698: from per_collective_agreements pca
1699: where pca.collective_agreement_id = pcrr.collective_agreement_id
1700: and pca.STATUS = 'A'

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

1702: AND EXISTS (select 'x'
1703: from per_cagr_entitlements pce
1704: where pce.cagr_entitlement_id = pcrr.cagr_entitlement_id
1705: and pce.STATUS = 'A'
1706: and p_params.effective_date between pce.START_DATE and nvl(pce.END_DATE,hr_general.end_of_time))
1707: AND ((pcrr.cagr_entitlement_line_id is not null
1708: and EXISTS (select 'x'
1709: from per_cagr_entitlement_lines_f pcel
1710: where pcel.cagr_entitlement_line_id = pcrr.cagr_entitlement_line_id

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

1728: SELECT *
1729: FROM per_cagr_entitlement_lines_f pcel
1730: WHERE pcel.CAGR_ENTITLEMENT_LINE_ID = v_line_id
1731: AND p_effective_date BETWEEN pcel.EFFECTIVE_START_DATE
1732: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);
1733: --
1734: -- Cursor to return entitlement line values on the effective_date
1735: --
1736: v_csr_rr_rec csr_cagr_retained_rights%ROWTYPE;

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

2030: SELECT *
2031: FROM per_cagr_retained_rights pcrr
2032: WHERE pcrr.assignment_id = p_params.assignment_id
2033: AND p_params.effective_date BETWEEN pcrr.START_DATE
2034: AND nvl(pcrr.END_DATE,hr_general.end_of_time)
2035: AND EXISTS (select 'X' from per_all_assignments_f asg
2036: where asg.assignment_id = p_params.assignment_id
2037: and p_params.effective_date BETWEEN asg.effective_start_date
2038: AND asg.effective_end_date

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

2046: from per_cagr_entitlements pce
2047: where pce.cagr_entitlement_id = pcrr.cagr_entitlement_id
2048: and pce.STATUS = 'A'
2049: and p_params.effective_date BETWEEN pce.START_DATE
2050: AND nvl(pce.END_DATE,hr_general.end_of_time))
2051: AND ((pcrr.cagr_entitlement_line_id is not null
2052: and EXISTS (select 'x'
2053: from per_cagr_entitlement_lines_f pcel
2054: where pcel.cagr_entitlement_line_id = pcrr.cagr_entitlement_line_id

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

2065: SELECT *
2066: FROM per_cagr_entitlements pce
2067: WHERE pce.CAGR_ENTITLEMENT_ID = v_ent_id
2068: AND p_params.effective_date BETWEEN pce.START_DATE
2069: AND nvl(pce.END_DATE,hr_general.end_of_time);
2070: --
2071: -- Cursor to return active entitlement line values on the effective_date
2072: --
2073: CURSOR csr_cagr_lines (v_line_id in NUMBER, v_cagr_id IN NUMBER) IS

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

2074: SELECT *
2075: FROM per_cagr_entitlement_lines_f pcel
2076: WHERE pcel.CAGR_ENTITLEMENT_LINE_ID = v_line_id
2077: AND p_params.effective_date BETWEEN pcel.EFFECTIVE_START_DATE
2078: AND nvl(pcel.EFFECTIVE_END_DATE,hr_general.end_of_time);
2079: --
2080: -- Cursor to get the beneficial rule info for specific entitlement_item
2081: --
2082: cursor csr_ben_rule (l_cagr_entitlement_item_id IN NUMBER) is