APPS.PAY_DK_TCR dependencies on HR_ORGANIZATION_UNITS

Line 42: FROM hr_organization_units o1

38: /*Legal Employer Information*/
39: Cursor csr_Legal_Emp_Details (csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
40: IS
41: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
42: FROM hr_organization_units o1
43: , hr_organization_information hoi1
44: , hr_organization_information hoi2
45: WHERE o1.business_group_id =p_business_group_id
46: AND hoi1.organization_id = o1.organization_id

Line 61: SELECT organization_id FROM hr_organization_units

57: IS
58: SELECT * FROM hr_organization_information
59: WHERE org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
60: AND organization_id IN (
61: SELECT organization_id FROM hr_organization_units
62: WHERE business_group_id= p_business_group_id);
63:
64: sp service_provider_details%ROWTYPE;
65: