APPS.PAY_DK_ARCHIVE_EIN dependencies on HR_ORGANIZATION_UNITS

Line 157: l_emp_id hr_organization_units.organization_id%TYPE ;

153: l_count NUMBER := 0;
154: l_business_group_id NUMBER;
155: l_test_submission varchar2(1);
156: l_company_terminating varchar2(1);
157: l_emp_id hr_organization_units.organization_id%TYPE ;
158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

Line 158: l_le_name hr_organization_units.name%TYPE ;

154: l_business_group_id NUMBER;
155: l_test_submission varchar2(1);
156: l_company_terminating varchar2(1);
157: l_emp_id hr_organization_units.organization_id%TYPE ;
158: l_le_name hr_organization_units.name%TYPE ;
159: l_business_id hr_organization_information.org_information1%TYPE ;
160: l_cvr_number hr_organization_information.org_information1%TYPE ;
161: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
162: l_org_type hr_organization_information.org_information1%TYPE ;

Line 173: FROM hr_organization_units o1

169: /*Legal Employer Information*/
170: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
171: IS
172: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
173: FROM hr_organization_units o1
174: , hr_organization_information hoi1
175: , hr_organization_information hoi2
176: WHERE o1.business_group_id =l_business_group_id
177: AND hoi1.organization_id = o1.organization_id

Line 192: select organization_id from hr_organization_units

188: is
189: select * from hr_organization_information
190: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
191: and organization_id in (
192: select organization_id from hr_organization_units
193: where business_group_id= l_business_group_id);
194:
195: sp service_provider_details%rowtype;
196:

Line 768: bg_id hr_organization_units.business_group_id%type

764:
765: /* Cursor to get SE Number, PUCODE at HR Org level */
766:
767: CURSOR csr_get_hr_org_info(
768: bg_id hr_organization_units.business_group_id%type
769: ,hr_org_id hr_organization_information.organization_id%type) IS
770: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
771: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
772: FROM hr_organization_units o1

Line 772: FROM hr_organization_units o1

768: bg_id hr_organization_units.business_group_id%type
769: ,hr_org_id hr_organization_information.organization_id%type) IS
770: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
771: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
772: FROM hr_organization_units o1
773: , hr_organization_information hoi1
774: , hr_organization_information hoi2
775: WHERE o1.business_group_id =bg_id
776: AND hoi1.organization_id = o1.organization_id

Line 805: FROM hr_organization_units o1

801: /* Cursor to get the details of the legal employer */
802: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
803: IS
804: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
805: FROM hr_organization_units o1
806: , hr_organization_information hoi1
807: , hr_organization_information hoi2
808: WHERE o1.business_group_id =g_business_group_id
809: AND hoi1.organization_id = o1.organization_id