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_ENTITLEMENT_LINES_F

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 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 335: per_cagr_entitlement_lines_f pcel

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
338: AND nvl(cagr.END_DATE, hr_general.end_of_time)
339: AND cagr.STATUS = 'A'

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 426: per_cagr_entitlement_lines_f pcel

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
429: AND asg.effective_end_date
430: AND asg.PRIMARY_FLAG = 'Y'

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 519: per_cagr_entitlement_lines_f pcel

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
522: AND asg.effective_end_date
523: AND asg.PRIMARY_FLAG = 'Y'

Line 570: v_value per_cagr_entitlement_lines_f.value%TYPE;

566: v_ben_row NUMBER(10) := 0;
567: v_beneficial_value VARCHAR2(30) := NULL;
568: v_beneficial_rule per_cagr_entitlement_items.beneficial_rule%TYPE;
569: v_beneficial_rule_vs_id per_cagr_entitlement_items.beneficial_rule_value_set_id%TYPE;
570: v_value per_cagr_entitlement_lines_f.value%TYPE;
571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;

Line 571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;

567: v_beneficial_value VARCHAR2(30) := NULL;
568: v_beneficial_rule per_cagr_entitlement_items.beneficial_rule%TYPE;
569: v_beneficial_rule_vs_id per_cagr_entitlement_items.beneficial_rule_value_set_id%TYPE;
570: v_value per_cagr_entitlement_lines_f.value%TYPE;
571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;

Line 572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;

568: v_beneficial_rule per_cagr_entitlement_items.beneficial_rule%TYPE;
569: v_beneficial_rule_vs_id per_cagr_entitlement_items.beneficial_rule_value_set_id%TYPE;
570: v_value per_cagr_entitlement_lines_f.value%TYPE;
571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;

Line 573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;

569: v_beneficial_rule_vs_id per_cagr_entitlement_items.beneficial_rule_value_set_id%TYPE;
570: v_value per_cagr_entitlement_lines_f.value%TYPE;
571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;
577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;

Line 574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;

570: v_value per_cagr_entitlement_lines_f.value%TYPE;
571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;
577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;
578: v_rule_inconclusive BOOLEAN := FALSE;

Line 575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;

571: v_range_from per_cagr_entitlement_lines_f.range_from%TYPE;
572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;
577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;
578: v_rule_inconclusive BOOLEAN := FALSE;
579: v_return BOOLEAN := FALSE;

Line 576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;

572: v_range_to per_cagr_entitlement_lines_f.range_to%TYPE;
573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;
577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;
578: v_rule_inconclusive BOOLEAN := FALSE;
579: v_return BOOLEAN := FALSE;
580: v_write_flag BOOLEAN := FALSE;

Line 577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;

573: v_grade_spine_id per_cagr_entitlement_lines_f.grade_spine_id%TYPE;
574: v_parent_spine_id per_cagr_entitlement_lines_f.parent_spine_id%TYPE;
575: v_step_id per_cagr_entitlement_lines_f.step_id%TYPE;
576: v_from_step_id per_cagr_entitlement_lines_f.from_step_id%TYPE;
577: v_to_step_id per_cagr_entitlement_lines_f.to_step_id%TYPE;
578: v_rule_inconclusive BOOLEAN := FALSE;
579: v_return BOOLEAN := FALSE;
580: v_write_flag BOOLEAN := FALSE;
581: v_primary_flag BOOLEAN := FALSE;

Line 1781: from per_cagr_entitlement_lines_f pcel

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
1783: and pcel.STATUS = 'A'
1784: and p_params.effective_date between pcel.effective_start_date
1785: and pcel.effective_end_date))

Line 1801: FROM per_cagr_entitlement_lines_f pcel

1797: -- used for un-frozen retained right ent lines
1798: --
1799: CURSOR csr_cagr_lines (v_line_id in NUMBER, v_cagr_id IN NUMBER) IS
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: --

Line 2125: from per_cagr_entitlement_lines_f pcel

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
2127: and pcel.STATUS = 'A'
2128: and p_params.effective_date between pcel.effective_start_date
2129: and pcel.effective_end_date))

Line 2147: FROM per_cagr_entitlement_lines_f pcel

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
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: --