DBA Data[Home] [Help]

APPS.FF_FORMULAS_F_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 112: -- Cursor to check if the formula is referenced in pay_element_types_f table.

108: or pap.co_formula_id = p_formula_id
109: or pap.payroll_formula_id = p_formula_id;
110:
111: --
112: -- Cursor to check if the formula is referenced in pay_element_types_f table.
113: --
114: cursor csr_element_type is
115: select 1
116: from pay_element_types_f pet

Line 116: from pay_element_types_f pet

112: -- Cursor to check if the formula is referenced in pay_element_types_f table.
113: --
114: cursor csr_element_type is
115: select 1
116: from pay_element_types_f pet
117: where ( pet.proration_formula_id = p_formula_id
118: or pet.formula_id = p_formula_id
119: or pet.iterative_formula_id = p_formula_id )
120: and pet.effective_start_date <= p_validation_end_date