APPS.HR_ES_UTILITY dependencies on FF_FORMULAS_F

Line 395: l_formula_id ff_formulas_f.formula_id%type;

391: PROCEDURE validate_cif(p_org_info VARCHAR2) is
392:
393: l_inputs ff_exec.inputs_t;
394: l_outputs ff_exec.outputs_t;
395: l_formula_id ff_formulas_f.formula_id%type;
396: l_formula_mesg varchar2(50);
397: l_effective_start_date ff_formulas_f.effective_start_date%type;
398:
399: CURSOR get_formula_id is

Line 397: l_effective_start_date ff_formulas_f.effective_start_date%type;

393: l_inputs ff_exec.inputs_t;
394: l_outputs ff_exec.outputs_t;
395: l_formula_id ff_formulas_f.formula_id%type;
396: l_formula_mesg varchar2(50);
397: l_effective_start_date ff_formulas_f.effective_start_date%type;
398:
399: CURSOR get_formula_id is
400: SELECT formula_id, effective_start_date
401: FROM ff_formulas_f

Line 401: FROM ff_formulas_f

397: l_effective_start_date ff_formulas_f.effective_start_date%type;
398:
399: CURSOR get_formula_id is
400: SELECT formula_id, effective_start_date
401: FROM ff_formulas_f
402: WHERE formula_name = 'ES_CIF_VALIDATION'
403: AND business_group_id is null
404: AND legislation_code = 'ES'
405: AND sysdate BETWEEN effective_start_date AND effective_end_date;

Line 461: l_formula_id ff_formulas_f.formula_id%type;

457: PROCEDURE validate_cac(p_org_info VARCHAR2) is
458:
459: l_inputs ff_exec.inputs_t;
460: l_outputs ff_exec.outputs_t;
461: l_formula_id ff_formulas_f.formula_id%type;
462: l_formula_mesg varchar2(50);
463: l_effective_start_date ff_formulas_f.effective_start_date%type;
464:
465: CURSOR get_formula_id is

Line 463: l_effective_start_date ff_formulas_f.effective_start_date%type;

459: l_inputs ff_exec.inputs_t;
460: l_outputs ff_exec.outputs_t;
461: l_formula_id ff_formulas_f.formula_id%type;
462: l_formula_mesg varchar2(50);
463: l_effective_start_date ff_formulas_f.effective_start_date%type;
464:
465: CURSOR get_formula_id is
466: SELECT formula_id, effective_start_date
467: FROM ff_formulas_f

Line 467: FROM ff_formulas_f

463: l_effective_start_date ff_formulas_f.effective_start_date%type;
464:
465: CURSOR get_formula_id is
466: SELECT formula_id, effective_start_date
467: FROM ff_formulas_f
468: WHERE formula_name = 'ES_CAC_VALIDATION'
469: AND business_group_id is null
470: AND legislation_code = 'ES'
471: AND sysdate BETWEEN effective_start_date AND effective_end_date;