DBA Data[Home] [Help]

APPS.PAY_IP_ROUTE_SUPPORT dependencies on PER_BUSINESS_GROUPS

Line 20: FROM per_business_groups bg

16: -- ('L') in the format DD/MM.
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';