DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_LEGISLATION_RULES

Line 1802: FROM pay_legislation_rules plr

1798: /* Added to check the legislation rule for bug #5846278 */
1799: CURSOR get_legislation_rule
1800: IS
1801: SELECT plr.rule_mode
1802: FROM pay_legislation_rules plr
1803: WHERE plr.legislation_code = 'AU'
1804: AND plr.rule_type ='ADVANCED_RETRO';
1805:
1806: rec_retro_Allowances Get_retro_Allowances%ROWTYPE;

Line 1826: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;

1822: orig_eff_date date;
1823: retro_eff_date date;
1824: time_span varchar2(10);
1825: retro_type varchar2(50);
1826: l_adv_retro_flag pay_legislation_rules.rule_mode%TYPE;
1827:
1828: Begin
1829: g_debug := hr_utility.debug_enabled;
1830: ret_counter := 1;