APPS.PAY_AU_LEAVE_LIABILITY dependencies on PAY_AU_MODULES

Line 356: l_business_group_id pay_au_modules.business_group_id%type ;

352: l_hourly_rate_formula_const constant ff_formulas_f.formula_name%type := 'AU_HOURLY_RATE_FORMULA' ;
353:
354: l_procedure_name varchar2(61) ;
355: l_hourly_rate number := null ;
356: l_business_group_id pay_au_modules.business_group_id%type ;
357: l_legislation_code pay_au_modules.legislation_code%type ;
358: l_formula_name ff_formulas_f.formula_name%type ;
359:
360: e_bad_module exception ;

Line 357: l_legislation_code pay_au_modules.legislation_code%type ;

353:
354: l_procedure_name varchar2(61) ;
355: l_hourly_rate number := null ;
356: l_business_group_id pay_au_modules.business_group_id%type ;
357: l_legislation_code pay_au_modules.legislation_code%type ;
358: l_formula_name ff_formulas_f.formula_name%type ;
359:
360: e_bad_module exception ;
361: e_bad_hourly_rate exception ;

Line 377: l_module_id pay_au_modules.module_id%type ;

373: or (f.legislation_code = p_legislation_code)) ;
374: procedure execute_formula(p_formula_name varchar2) is
375:
376: l_procedure_name varchar2(61) ;
377: l_module_id pay_au_modules.module_id%type ;
378:
379: cursor c_module(p_formula_name varchar2
380: ,p_business_group_id number
381: ,p_legislation_code varchar2) is

Line 383: from pay_au_modules m

379: cursor c_module(p_formula_name varchar2
380: ,p_business_group_id number
381: ,p_legislation_code varchar2) is
382: select m.module_id
383: from pay_au_modules m
384: where m.formula_name = p_formula_name
385: and m.enabled_flag = 'Y'
386: and ((m.business_group_id is null
387: and m.legislation_code is null)

Line 451: -- team. We will ship the module definition in pay_au_modules

447: ,l_legislation_code) ;
448:
449: -- Execute the hourly rate formula.
450: -- (the hourly rate formula will be written by the implementation
451: -- team. We will ship the module definition in pay_au_modules
452: -- and define the specification of the formula).
453:
454:
455: