DBA Data[Home] [Help]

APPS.PAY_ZA_PAYSLIP_ARCHIVE dependencies on FF_FORMULAS_F

Line 186: ff_formulas_f fff

182: p_effective_date date
183: ) is
184: select pet.formula_id
185: from pay_element_types_f pet,
186: ff_formulas_f fff
187: where pet.element_type_id = p_element_type_id
188: and pet.formula_id = fff.formula_id
189: and fff.formula_name = 'ONCE_EACH_PERIOD'
190: and p_effective_date between fff.effective_start_date and fff.effective_end_date