APPS.PER_CAGR_EVALUATION_PKG dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 43: TYPE entitlement_items IS TABLE OF per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE

39:
40: TYPE cagr_asg_table IS TABLE OF cagr_asg_rec
41: INDEX BY BINARY_INTEGER;
42:
43: TYPE entitlement_items IS TABLE OF per_cagr_entitlement_items.cagr_entitlement_item_id%TYPE
44: INDEX BY BINARY_INTEGER;
45:
46: TYPE assignment_table IS TABLE OF asg_rec
47: INDEX BY BINARY_INTEGER;

Line 212: FROM per_cagr_entitlement_items item

208: --
209:
210: CURSOR csr_BE_drive_benmngle IS
211: SELECT item.opt_id
212: FROM per_cagr_entitlement_items item
213: WHERE item.cagr_entitlement_item_id = p_params.entitlement_item_id
214: AND exists (select 'x'
215: from per_collective_agreements cagr, per_all_assignments_f asg
216: where cagr.status = 'A'

Line 334: per_cagr_entitlement_items pcei,

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

Line 425: per_cagr_entitlement_items pcei,

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
429: AND asg.effective_end_date

Line 518: per_cagr_entitlement_items pcei,

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
522: AND asg.effective_end_date

Line 568: v_beneficial_rule per_cagr_entitlement_items.beneficial_rule%TYPE;

564: v_ent_count NUMBER(10) := 0;
565: v_last_dataitem_id NUMBER(10) := NULL;
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;

Line 569: v_beneficial_rule_vs_id per_cagr_entitlement_items.beneficial_rule_value_set_id%TYPE;

565: v_last_dataitem_id NUMBER(10) := NULL;
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;

Line 2156: from per_cagr_entitlement_items pcei

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
2155: SELECT beneficial_rule, beneficial_rule_value_set_id
2156: from per_cagr_entitlement_items pcei
2157: where pcei.cagr_entitlement_item_id = l_cagr_entitlement_item_id;
2158: --
2159: --
2160: --