DBA Data[Home] [Help]

APPS.PAY_AU_PAYE_FF dependencies on PER_BUSINESS_GROUPS

Line 1514: p_business_group_id IN per_business_groups.business_group_id%TYPE

1510: */
1511:
1512: FUNCTION check_if_enhanced_retro
1513: (
1514: p_business_group_id IN per_business_groups.business_group_id%TYPE
1515: )RETURN VARCHAR2
1516: IS
1517:
1518: CURSOR get_legislation_rule

Line 1519: (c_business_group_id IN per_business_groups.business_group_id%TYPE)

1515: )RETURN VARCHAR2
1516: IS
1517:
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

Line 1523: ,per_business_groups pbg

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'
1527: AND pbg.legislation_code = 'AU';