APPS.HR_NL_EXTRA_ASG_RULES dependencies on HR_ORGANIZATION_INFORMATION

Line 664: FROM hr_organization_information hoi

660: AND paa.effective_end_date;
661:
662: CURSOR csr_get_emp_chg_flag(p_business_group_id NUMBER) IS
663: SELECT hoi.org_information8
664: FROM hr_organization_information hoi
665: WHERE hoi.organization_id = p_business_group_id
666: AND hoi.org_information_context = 'NL_BG_INFO';
667:
668: CURSOR csr_get_payroll_employer(p_payroll_id NUMBER