APPS.FF_FORMULAS_F_PKG dependencies on PER_CAGR_ENTITLEMENTS

Line 23: -- 5. PER_CAGR_ENTITLEMENTS --

19: -- 1. PAY_AU_MODULES --
20: -- 2. PAY_SHADOW_ELEMENT_TYPES --
21: -- 3. PER_CAGR_ENTITLEMENT_ITEMS --
22: -- 4. PER_CAGR_RETAINED_RIGHTS --
23: -- 5. PER_CAGR_ENTITLEMENTS --
24: -- 6. PER_CAGR_ENTITLEMENT_RESULTS --
25: -- 7. PAY_ACCRUAL_PLANS --
26: -- Included the delete integrity check for proration formula in --
27: -- csr_element_type cursor and added input parameter p_formula_details. --

Line 124: -- Cursor to check if the formuls is referenced in per_cagr_entitlements table.

120: and pet.effective_start_date <= p_validation_end_date
121: and pet.effective_end_date >= p_validation_start_date;
122:
123: --
124: -- Cursor to check if the formuls is referenced in per_cagr_entitlements table.
125: --
126: cursor csr_per_cagr_entitlements is
127: select pce.formula_id
128: from per_cagr_entitlements pce

Line 126: cursor csr_per_cagr_entitlements is

122:
123: --
124: -- Cursor to check if the formuls is referenced in per_cagr_entitlements table.
125: --
126: cursor csr_per_cagr_entitlements is
127: select pce.formula_id
128: from per_cagr_entitlements pce
129: where pce.formula_id = p_formula_id
130: and pce.start_date <= p_validation_end_date

Line 128: from per_cagr_entitlements pce

124: -- Cursor to check if the formuls is referenced in per_cagr_entitlements table.
125: --
126: cursor csr_per_cagr_entitlements is
127: select pce.formula_id
128: from per_cagr_entitlements pce
129: where pce.formula_id = p_formula_id
130: and pce.start_date <= p_validation_end_date
131: and (pce.end_date is null or pce.end_date >= p_validation_start_date );
132:

Line 351: open csr_per_cagr_entitlements;

347: close csr_per_cagr_entitle_results;
348: end if;
349:
350: --
351: open csr_per_cagr_entitlements;
352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');

Line 352: fetch csr_per_cagr_entitlements into v_dummy;

348: end if;
349:
350: --
351: open csr_per_cagr_entitlements;
352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;

Line 353: if csr_per_cagr_entitlements%found then

349:
350: --
351: open csr_per_cagr_entitlements;
352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;
357: else

Line 354: close csr_per_cagr_entitlements;

350: --
351: open csr_per_cagr_entitlements;
352: fetch csr_per_cagr_entitlements into v_dummy;
353: if csr_per_cagr_entitlements%found then
354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;
357: else
358: close csr_per_cagr_entitlements;

Line 358: close csr_per_cagr_entitlements;

354: close csr_per_cagr_entitlements;
355: hr_utility.set_message(801, 'PAY_34034_FORMULA_DEL_CAGR');
356: hr_utility.raise_error;
357: else
358: close csr_per_cagr_entitlements;
359: end if;
360: --
361: open csr_input_value;
362: fetch csr_input_value into v_dummy;