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 PAY_SHADOW_ELEMENT_TYPES

Line 20: -- 2. PAY_SHADOW_ELEMENT_TYPES --

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 --
24: -- 6. PER_CAGR_ENTITLEMENT_RESULTS --

Line 177: -- Cursor to check if the formula is referenced in pay_shadow_element_types table.

173:
174: or (pam.legislation_code is null and pam.business_group_id=p_formula_details.business_group_id)
175: );
176: --
177: -- Cursor to check if the formula is referenced in pay_shadow_element_types table.
178: --
179:
180: cursor csr_element_template is
181: select 1

Line 182: from pay_shadow_element_types pset

178: --
179:
180: cursor csr_element_template is
181: select 1
182: from pay_shadow_element_types pset
183: where (pset.skip_formula = p_formula_details.formula_name or pset.iterative_formula_name=
184: p_formula_details.formula_name )
185: and exists(
186: select null