DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_LEGISLATION_RULES

Line 307: FROM pay_legislation_rules plr

303:
304: CURSOR get_legislation_rule
305: IS
306: SELECT plr.rule_mode
307: FROM pay_legislation_rules plr
308: WHERE plr.legislation_code = 'AU'
309: AND plr.rule_type ='ADVANCED_RETRO';
310:
311: rec_retro_Allowances Get_retro_Allowances%ROWTYPE;

Line 328: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;

324: orig_eff_date date;
325: retro_eff_date date;
326: time_span varchar2(10);
327: retro_type varchar2(50);
328: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;
329:
330: Begin
331: g_debug := hr_utility.debug_enabled;
332: ret_counter := 1;