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.FF_FORMULAS_F_PKG dependencies on PER_CAGR_RETAINED_RIGHTS

Line 22: -- 4. PER_CAGR_RETAINED_RIGHTS --

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 --
26: -- Included the delete integrity check for proration formula in --

Line 152: -- Cursor to check if the formula is referenced in per_cagr_retained_rights table.

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:
151: --
152: -- Cursor to check if the formula is referenced in per_cagr_retained_rights table.
153: --
154: cursor csr_cagr_retained_rights is
155: select pcrr.formula_id
156: from per_cagr_retained_rights pcrr

Line 156: from per_cagr_retained_rights pcrr

152: -- Cursor to check if the formula is referenced in per_cagr_retained_rights table.
153: --
154: cursor csr_cagr_retained_rights is
155: select pcrr.formula_id
156: from per_cagr_retained_rights pcrr
157: where pcrr.formula_id = p_formula_id
158: and pcrr.start_date <= p_validation_end_date
159: and (pcrr.end_date is null or pcrr.end_date >= p_validation_start_date );
160: