DBA Data[Home] [Help]

APPS.FF_FORMULAS_F_PKG dependencies on PAY_AU_MODULES

Line 19: -- 1. PAY_AU_MODULES --

15: -- None. --
16: -- History --
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 --

Line 163: -- Cursor to check if the formula is referenced in pay_au_modules table.

159: and (pcrr.end_date is null or pcrr.end_date >= p_validation_start_date );
160:
161:
162: --
163: -- Cursor to check if the formula is referenced in pay_au_modules table.
164: --
165: cursor csr_au_modules is
166: select 1
167: from pay_au_modules pam

Line 167: from pay_au_modules pam

163: -- Cursor to check if the formula is referenced in pay_au_modules table.
164: --
165: cursor csr_au_modules is
166: select 1
167: from pay_au_modules pam
168: where pam.formula_name = p_formula_details.formula_name
169: and (
170: (pam.legislation_code is null and pam.business_group_id is null)
171: