DBA Data[Home] [Help]

APPS.PAY_IP_ROUTE_SUPPORT dependencies on PAY_LEGISLATION_RULES

Line 21: ,pay_legislation_rules ru

17: --
18: CURSOR csr_base_tax_year(p_business_group_id NUMBER, p_effective_date DATE) IS
19: SELECT TO_DATE(ru.rule_mode || '/' || TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
20: FROM per_business_groups bg
21: ,pay_legislation_rules ru
22: WHERE bg.business_group_id = p_business_group_id
23: AND ru.legislation_code = bg.legislation_code
24: AND ru.rule_type = 'L';
25: --