APPS.HR_ES_UTILITY dependencies on FF_FORMULAS_F

Line 334: l_formula_id ff_formulas_f.formula_id%type;

330: PROCEDURE validate_cif(p_org_info VARCHAR2) is
331:
332: l_inputs ff_exec.inputs_t;
333: l_outputs ff_exec.outputs_t;
334: l_formula_id ff_formulas_f.formula_id%type;
335: l_formula_mesg varchar2(50);
336: l_effective_start_date ff_formulas_f.effective_start_date%type;
337:
338: CURSOR get_formula_id is

Line 336: l_effective_start_date ff_formulas_f.effective_start_date%type;

332: l_inputs ff_exec.inputs_t;
333: l_outputs ff_exec.outputs_t;
334: l_formula_id ff_formulas_f.formula_id%type;
335: l_formula_mesg varchar2(50);
336: l_effective_start_date ff_formulas_f.effective_start_date%type;
337:
338: CURSOR get_formula_id is
339: SELECT formula_id, effective_start_date
340: FROM ff_formulas_f

Line 340: FROM ff_formulas_f

336: l_effective_start_date ff_formulas_f.effective_start_date%type;
337:
338: CURSOR get_formula_id is
339: SELECT formula_id, effective_start_date
340: FROM ff_formulas_f
341: WHERE formula_name = 'ES_CIF_VALIDATION'
342: AND business_group_id is null
343: AND legislation_code = 'ES'
344: AND sysdate BETWEEN effective_start_date AND effective_end_date;

Line 400: l_formula_id ff_formulas_f.formula_id%type;

396: PROCEDURE validate_cac(p_org_info VARCHAR2) is
397:
398: l_inputs ff_exec.inputs_t;
399: l_outputs ff_exec.outputs_t;
400: l_formula_id ff_formulas_f.formula_id%type;
401: l_formula_mesg varchar2(50);
402: l_effective_start_date ff_formulas_f.effective_start_date%type;
403:
404: CURSOR get_formula_id is

Line 402: l_effective_start_date ff_formulas_f.effective_start_date%type;

398: l_inputs ff_exec.inputs_t;
399: l_outputs ff_exec.outputs_t;
400: l_formula_id ff_formulas_f.formula_id%type;
401: l_formula_mesg varchar2(50);
402: l_effective_start_date ff_formulas_f.effective_start_date%type;
403:
404: CURSOR get_formula_id is
405: SELECT formula_id, effective_start_date
406: FROM ff_formulas_f

Line 406: FROM ff_formulas_f

402: l_effective_start_date ff_formulas_f.effective_start_date%type;
403:
404: CURSOR get_formula_id is
405: SELECT formula_id, effective_start_date
406: FROM ff_formulas_f
407: WHERE formula_name = 'ES_CAC_VALIDATION'
408: AND business_group_id is null
409: AND legislation_code = 'ES'
410: AND sysdate BETWEEN effective_start_date AND effective_end_date;