DBA Data[Home] [Help]

APPS.PAY_ELEMENT_DATA_PUMP dependencies on FF_FORMULAS_F

Line 250: From ff_formulas_f f1,

246: Begin
247:
248: Select formula_id
249: into l_formula_id
250: From ff_formulas_f f1,
251: ff_formula_types f2
252: Where f1.formula_type_id = f2.formula_type_id
253: and f2.formula_type_name = 'Element Skip'
254: and p_effective_date between f1.effective_start_date and

Line 313: From ff_formulas_f f1, ff_formula_types f2

309: l_formula_id number;
310: Begin
311: Select formula_id
312: INTO l_formula_id
313: From ff_formulas_f f1, ff_formula_types f2
314: Where f1.formula_type_id = f2.formula_type_id
315: and f2.formula_type_name = 'Net to Gross'
316: and p_effective_date between f1.effective_start_date and
317: f1.effective_end_date

Line 413: From ff_formulas_f f1, ff_formula_types f2

409: Begin
410:
411: Select formula_id
412: INTO l_formula_id
413: From ff_formulas_f f1, ff_formula_types f2
414: Where f1.formula_type_id = f2.formula_type_id
415: and f2.formula_type_name = 'Payroll Run Proration'
416: and p_effective_date between f1.effective_start_date and
417: f1.effective_end_date

Line 565: From ff_formulas_f ff,

561:
562: Begin
563: Select formula_id
564: INTO l_formula_id
565: From ff_formulas_f ff,
566: ff_formula_types ft
567: Where nvl(ff.legislation_code,
568: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
569: nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')