APPS.PAY_IP_ROUTE_SUPPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 98: FROM hr_organization_information HOI

94: --
95: CURSOR csr_base_fiscal_year(p_business_group_id NUMBER, p_effective_date DATE) IS
96: SELECT TO_DATE(TO_CHAR(fnd_date.canonical_to_date(hoi.org_information11), 'DD/MM/')
97: || TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
98: FROM hr_organization_information HOI
99: WHERE UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
100: AND hoi.organization_id = p_business_group_id;
101: --
102: --