APPS.PAY_SG_DEDUCTIONS dependencies on FF_FORMULAS_F

Line 638: cursor c_get_pro_formula_id (c_formula_name ff_formulas_f.formula_name%type,

634: and c_date between paf.effective_start_date and paf.effective_end_date )
635: and c_date between target.effective_start_date and target.effective_end_date;
636:
637: /* Bug 9112449, added function to get working days/custom days from CPF_CAL_METHOD formula */
638: cursor c_get_pro_formula_id (c_formula_name ff_formulas_f.formula_name%type,
639: c_date DATE)
640: is
641: select formula_id
642: from ff_formulas_f

Line 642: from ff_formulas_f

638: cursor c_get_pro_formula_id (c_formula_name ff_formulas_f.formula_name%type,
639: c_date DATE)
640: is
641: select formula_id
642: from ff_formulas_f
643: where formula_name like c_formula_name
644: and c_date between effective_start_date and effective_end_date
645: and (business_group_id is not null or legislation_code = 'SG');
646:

Line 647: l_pro_formula_id ff_formulas_f.formula_id%type;

643: where formula_name like c_formula_name
644: and c_date between effective_start_date and effective_end_date
645: and (business_group_id is not null or legislation_code = 'SG');
646:
647: l_pro_formula_id ff_formulas_f.formula_id%type;
648: l_pro_check varchar2(1);
649:
650: l_inputs ff_exec.inputs_t;
651: l_outputs ff_exec.outputs_t;

Line 1556: from ff_formulas_f

1552: l_formula_id number;
1553: --
1554: cursor c_formula_id (c_formula_name varchar2, c_effective_date date) is
1555: select formula_id, effective_start_date
1556: from ff_formulas_f
1557: where formula_name = c_formula_name
1558: and legislation_code = 'SG'
1559: and c_effective_date between effective_start_date and effective_end_date;
1560: