APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_LEGISLATION_RULES

Line 2801: FROM pay_legislation_rules plr

2797: /* Added to check the legislation rule for bug #5846278 */
2798: CURSOR get_legislation_rule
2799: IS
2800: SELECT plr.rule_mode
2801: FROM pay_legislation_rules plr
2802: WHERE plr.legislation_code = 'AU'
2803: AND plr.rule_type ='ADVANCED_RETRO';
2804:
2805: rec_retro_Allowances Get_retro_Allowances%ROWTYPE;

Line 2825: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;

2821: orig_eff_date date;
2822: retro_eff_date date;
2823: time_span varchar2(10);
2824: retro_type varchar2(50);
2825: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;
2826:
2827: Begin
2828: g_debug := hr_utility.debug_enabled;
2829: ret_counter := 1;