DBA Data[Home] [Help]

APPS.PAY_MAG_UTILS dependencies on FF_FORMULAS_F

Line 203: FROM ff_formulas_f

199: -- Cursor to get the formula id for the specified formula.
200: --
201: CURSOR csr_formula IS
202: SELECT formula_id
203: FROM ff_formulas_f
204: WHERE legislation_code = p_legislation_code
205: AND formula_name = UPPER(p_formula_name)
206: AND p_session_date BETWEEN effective_start_date
207: AND effective_end_date;

Line 880: ff_formulas_f ff

876: ff.formula_name formula_name
877: FROM pay_magnetic_blocks pmb,
878: pay_magnetic_records pmr,
879: pay_magnetic_blocks pmb2,
880: ff_formulas_f ff
881: WHERE pmb.magnetic_block_id = p_magnetic_block_id
882: AND pmb.magnetic_block_id = pmr.magnetic_block_id
883: AND pmr.next_block_id = pmb2.magnetic_block_id (+)
884: AND pmr.formula_id = ff.formula_id