DBA Data[Home] [Help]

APPS.PAY_PPR_BUS dependencies on FF_FORMULA_TYPES

Line 556: from ff_formula_types ft, ff_formulas_f ff

552: Cursor c_chk_formula_id
553: is
554: select distinct ft.formula_type_name,
555: Decode(ft.formula_type_name,'Balance Adjustment','B','P') processing_rule
556: from ff_formula_types ft, ff_formulas_f ff
557: where ff.formula_type_id = ft.formula_type_id
558: and ff.formula_id = p_formula_id
559: and ((ff.legislation_code =
560: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))

Line 567: l_formula_type ff_formula_types.formula_type_name%type;

563: or ( ff.legislation_code is null and
564: ff.business_group_id is null));
565:
566: --
567: l_formula_type ff_formula_types.formula_type_name%type;
568: l_assignment_status per_assignment_status_types.user_status%type;
569: --
570: Begin
571: hr_utility.set_location('Entering:'||l_proc, 5);