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_ACCRUAL_PLANS

Line 25: -- 7. PAY_ACCRUAL_PLANS --

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
29: --

Line 101: -- Cursor to check if the formula is referenced in pay_accrual_plans table.

97: where pmr.formula_id = p_formula_id;
98:
99:
100: --
101: -- Cursor to check if the formula is referenced in pay_accrual_plans table.
102: --
103: cursor csr_accrual_plans is
104: select 1
105: from pay_accrual_plans pap

Line 105: from pay_accrual_plans pap

101: -- Cursor to check if the formula is referenced in pay_accrual_plans table.
102: --
103: cursor csr_accrual_plans is
104: select 1
105: from pay_accrual_plans pap
106: where pap.accrual_formula_id = p_formula_id
107: or pap.ineligibility_formula_id = p_formula_id
108: or pap.co_formula_id = p_formula_id
109: or pap.payroll_formula_id = p_formula_id;