APPS.FF_FORMULAS_F_PKG dependencies on PER_CAGR_ENTITLEMENT_ITEMS

Line 21: -- 3. PER_CAGR_ENTITLEMENT_ITEMS --

17: -- 13-Sep-04
18: -- Added delete integrity checks for the following tables --
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 --

Line 134: -- Cursor to check if the formula is referenced in per_cagr_entitlement_items table.

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:
133: --
134: -- Cursor to check if the formula is referenced in per_cagr_entitlement_items table.
135: --
136: cursor csr_per_cagr_entitle_items is
137: select pcei.beneficial_formula_id
138: from per_cagr_entitlement_items pcei

Line 138: from per_cagr_entitlement_items pcei

134: -- Cursor to check if the formula is referenced in per_cagr_entitlement_items table.
135: --
136: cursor csr_per_cagr_entitle_items is
137: select pcei.beneficial_formula_id
138: from per_cagr_entitlement_items pcei
139: where pcei.beneficial_formula_id = p_formula_id;
140:
141: --
142: -- Cursor to check if the formula is referenced in per_cagr_entitlement_results.