APPS.FF_FORMULAS_F_PKG dependencies on PER_CAGR_ENTITLEMENT_RESULTS

Line 24: -- 6. PER_CAGR_ENTITLEMENT_RESULTS --

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. --
28: -- Bug No 3703492

Line 142: -- Cursor to check if the formula is referenced in per_cagr_entitlement_results.

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.
143: --
144: cursor csr_per_cagr_entitle_results is
145: select pcer.formula_id
146: from per_cagr_entitlement_results pcer

Line 146: from per_cagr_entitlement_results pcer

142: -- Cursor to check if the formula is referenced in per_cagr_entitlement_results.
143: --
144: cursor csr_per_cagr_entitle_results is
145: select pcer.formula_id
146: from per_cagr_entitlement_results pcer
147: where pcer.formula_id = p_formula_id
148: and pcer.start_date <= p_validation_end_date
149: and (pcer.end_date is null or pcer.end_date >= p_validation_start_date );
150: