DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_LEGISLATION_RULES

Line 1773: FROM pay_legislation_rules plr

1769: CURSOR get_legislation_rule
1770: (c_business_group_id IN per_business_groups.business_group_id%TYPE)
1771: IS
1772: SELECT rule_mode
1773: FROM pay_legislation_rules plr
1774: ,per_business_groups pbg
1775: WHERE plr.legislation_code = pbg.legislation_code
1776: AND pbg.business_group_id = c_business_group_id
1777: AND plr.rule_type = 'ADVANCED_RETRO'

Line 2012: FROM pay_legislation_rules plr

2008: /* Bug 5846272 - Cursor to read the Advanced Retropay Legislation Rule */
2009: CURSOR get_legislation_rule
2010: IS
2011: SELECT plr.rule_mode
2012: FROM pay_legislation_rules plr
2013: WHERE plr.legislation_code = 'AU'
2014: AND plr.rule_type ='ADVANCED_RETRO';
2015:
2016: /* Bug 6139035 - Cursor to fetch Effective Date */

Line 2387: FROM pay_legislation_rules plr

2383:
2384: CURSOR get_legislation_rule
2385: IS
2386: SELECT plr.rule_mode
2387: FROM pay_legislation_rules plr
2388: WHERE plr.legislation_code = 'AU'
2389: AND plr.rule_type ='ADVANCED_RETRO';
2390:
2391:

Line 3787: FROM pay_legislation_rules plr

3783:
3784: CURSOR get_legislation_rule
3785: IS
3786: SELECT plr.rule_mode
3787: FROM pay_legislation_rules plr
3788: WHERE plr.legislation_code = 'AU'
3789: AND plr.rule_type ='ADVANCED_RETRO';
3790:
3791: