DBA Data[Home] [Help]

APPS.PAY_AU_LEAVE_LIABILITY dependencies on FF_FORMULAS_F

Line 352: l_hourly_rate_formula_const constant ff_formulas_f.formula_name%type := 'AU_HOURLY_RATE_FORMULA' ;

348: -----------------------------------------------------------------------------
349:
350: procedure hourly_rate is
351:
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 ;

Line 358: l_formula_name ff_formulas_f.formula_name%type ;

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 ;
362:

Line 368: from ff_formulas_f f

364: cursor c_formula (p_formula_name varchar2
365: ,p_business_group_id number
366: ,p_legislation_code varchar2) is
367: select f.formula_id
368: from ff_formulas_f f
369: where f.formula_name = p_formula_name
370: and ((f.business_group_id is null
371: and f.legislation_code is null)
372: or (f.business_group_id = p_business_group_id)