APPS.PAY_AU_GENERIC_CODE_CALLER dependencies on FF_FORMULAS_F

Line 991: l_formula_id ff_formulas_f.formula_id%type ;

987: (p_module_id in number
988: ,p_formula_name in varchar2) is
989:
990: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_formula' ;
991: l_formula_id ff_formulas_f.formula_id%type ;
992: l_business_group_id ff_formulas_f.business_group_id%type ;
993: l_legislation_code ff_formulas_f.legislation_code%type ;
994: l_parameter_store t_parameter_store_tab ;
995: l_inputs_counter number := 1 ;

Line 992: l_business_group_id ff_formulas_f.business_group_id%type ;

988: ,p_formula_name in varchar2) is
989:
990: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_formula' ;
991: l_formula_id ff_formulas_f.formula_id%type ;
992: l_business_group_id ff_formulas_f.business_group_id%type ;
993: l_legislation_code ff_formulas_f.legislation_code%type ;
994: l_parameter_store t_parameter_store_tab ;
995: l_inputs_counter number := 1 ;
996: l_outputs_counter number := 1 ;

Line 993: l_legislation_code ff_formulas_f.legislation_code%type ;

989:
990: l_procedure_name varchar2(61) := 'pay_au_generic_code_caller.execute_formula' ;
991: l_formula_id ff_formulas_f.formula_id%type ;
992: l_business_group_id ff_formulas_f.business_group_id%type ;
993: l_legislation_code ff_formulas_f.legislation_code%type ;
994: l_parameter_store t_parameter_store_tab ;
995: l_inputs_counter number := 1 ;
996: l_outputs_counter number := 1 ;
997: l_ff_inputs ff_exec.inputs_t ;

Line 1012: from ff_formulas_f f

1008: cursor c_formula (p_formula_name varchar2
1009: ,p_business_group_id number
1010: ,p_legislation_code varchar2) is
1011: select f.formula_id
1012: from ff_formulas_f f
1013: where f.formula_name = p_formula_name
1014: and ((f.business_group_id is null
1015: and f.legislation_code is null)
1016: or (f.business_group_id = p_business_group_id)