DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PAY_LEGISLATION_RULES

Line 1522: FROM pay_legislation_rules plr

1518: CURSOR get_legislation_rule
1519: (c_business_group_id IN per_business_groups.business_group_id%TYPE)
1520: IS
1521: SELECT rule_mode
1522: FROM pay_legislation_rules plr
1523: ,per_business_groups pbg
1524: WHERE plr.legislation_code = pbg.legislation_code
1525: AND pbg.business_group_id = c_business_group_id
1526: AND plr.rule_type = 'ADVANCED_RETRO'

Line 1761: FROM pay_legislation_rules plr

1757: /* Bug 5846272 - Cursor to read the Advanced Retropay Legislation Rule */
1758: CURSOR get_legislation_rule
1759: IS
1760: SELECT plr.rule_mode
1761: FROM pay_legislation_rules plr
1762: WHERE plr.legislation_code = 'AU'
1763: AND plr.rule_type ='ADVANCED_RETRO';
1764:
1765: /* Bug 6139035 - Cursor to fetch Effective Date */