APPS.PAY_DK_ARCHIVE_EHOL dependencies on HR_ORGANIZATION_UNITS

Line 251: l_emp_id hr_organization_units.organization_id%TYPE ;

247: l_count NUMBER := 0;
248: l_business_group_id NUMBER;
249: l_test_submission varchar2(1);
250: -- l_company_terminating varchar2(1); bug 10367494
251: l_emp_id hr_organization_units.organization_id%TYPE ;
252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;

Line 252: l_le_name hr_organization_units.name%TYPE ;

248: l_business_group_id NUMBER;
249: l_test_submission varchar2(1);
250: -- l_company_terminating varchar2(1); bug 10367494
251: l_emp_id hr_organization_units.organization_id%TYPE ;
252: l_le_name hr_organization_units.name%TYPE ;
253: l_business_id hr_organization_information.org_information1%TYPE ;
254: l_cvr_number hr_organization_information.org_information1%TYPE ;
255: l_sp_cvr_number hr_organization_information.org_information1%TYPE ;
256: l_org_type hr_organization_information.org_information1%TYPE ;

Line 276: FROM hr_organization_units o1

272: /*Legal Employer Information*/
273: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
274: IS
275: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
276: FROM hr_organization_units o1
277: , hr_organization_information hoi1
278: , hr_organization_information hoi2
279: WHERE o1.business_group_id =l_business_group_id
280: AND hoi1.organization_id = o1.organization_id

Line 298: FROM hr_organization_units o1

294: hoi2.ORG_INFORMATION3,
295: hoi2.ORG_INFORMATION4,
296: hoi2.ORG_INFORMATION5,
297: hoi2.ORG_INFORMATION6
298: FROM hr_organization_units o1
299: , hr_organization_information hoi1
300: , hr_organization_information hoi2
301: WHERE o1.business_group_id =l_business_group_id
302: AND hoi1.organization_id = o1.organization_id

Line 318: select organization_id from hr_organization_units

314: is
315: select * from hr_organization_information
316: where org_information_context = 'DK_SERVICE_PROVIDER_DETAILS'
317: and organization_id in (
318: select organization_id from hr_organization_units
319: where business_group_id= l_business_group_id);
320:
321: sp service_provider_details%rowtype;
322:

Line 365: hr_organization_units hou,

361: ptp.TIME_PERIOD_ID
362: FROM
363: pay_payrolls_f ppf,
364: per_assignments_f paf,
365: hr_organization_units hou,
366: hr_organization_information hoi,
367: hr_soft_coding_keyflex scl,
368: per_time_periods ptp
369: WHERE hou.business_group_id = l_business_group_id

Line 1056: FROM HR_ORGANIZATION_UNITS hou

1052: CURSOR csr_get_hol_entit(p_le_id NUMBER, p_effective_date DATE, p_business_group_id NUMBER) IS
1053: SELECT hoi2.ORG_INFORMATION1 DEFAULT_WORK_PATT
1054: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION3) HOURLY_ACCR_RATE
1055: ,fnd_number.canonical_to_number(hoi2.ORG_INFORMATION4) SAL_ALLOW_RATE
1056: FROM HR_ORGANIZATION_UNITS hou
1057: , HR_ORGANIZATION_INFORMATION hoi1
1058: , HR_ORGANIZATION_INFORMATION hoi2
1059: WHERE hou.business_group_id = p_business_group_id
1060: and hoi1.organization_id = hou.organization_id

Line 1088: FROM HR_ORGANIZATION_UNITS hou

1084: ,loc.REGION_1
1085: ,loc.REGION_2
1086: ,loc.REGION_3
1087: ,loc.style
1088: FROM HR_ORGANIZATION_UNITS hou
1089: , HR_ORGANIZATION_INFORMATION hoi1
1090: , HR_ORGANIZATION_INFORMATION hoi2
1091: , HR_LOCATIONS loc
1092: WHERE hou.business_group_id = p_business_group_id

Line 1183: bg_id hr_organization_units.business_group_id%type

1179:
1180: /* Cursor to get SE Number, PUCODE at HR Org level */
1181:
1182: CURSOR csr_get_hr_org_info(
1183: bg_id hr_organization_units.business_group_id%type
1184: ,hr_org_id hr_organization_information.organization_id%type) IS
1185: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
1186: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1187: FROM hr_organization_units o1

Line 1187: FROM hr_organization_units o1

1183: bg_id hr_organization_units.business_group_id%type
1184: ,hr_org_id hr_organization_information.organization_id%type) IS
1185: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4,
1186: hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1187: FROM hr_organization_units o1
1188: , hr_organization_information hoi1
1189: , hr_organization_information hoi2
1190: WHERE o1.business_group_id =bg_id
1191: AND hoi1.organization_id = o1.organization_id

Line 1221: FROM hr_organization_units o1

1217: /* Cursor to get the details of the legal employer */
1218: Cursor csr_Legal_Emp_Details ( csr_v_legal_emp_id hr_organization_information.ORGANIZATION_ID%TYPE)
1219: IS
1220: SELECT o1.name ,hoi2.ORG_INFORMATION1 , hoi2.ORG_INFORMATION2, hoi2.ORG_INFORMATION3, hoi2.ORG_INFORMATION4, hoi2.ORG_INFORMATION5, hoi2.ORG_INFORMATION6, hoi2.ORG_INFORMATION13
1221: FROM hr_organization_units o1
1222: , hr_organization_information hoi1
1223: , hr_organization_information hoi2
1224: WHERE o1.business_group_id =g_business_group_id
1225: AND hoi1.organization_id = o1.organization_id

Line 1516: FROM hr_organization_units o1

1512: hoi2.ORG_INFORMATION3,
1513: hoi2.ORG_INFORMATION4,
1514: hoi2.ORG_INFORMATION5,
1515: hoi2.ORG_INFORMATION6
1516: FROM hr_organization_units o1
1517: , hr_organization_information hoi1
1518: , hr_organization_information hoi2
1519: WHERE o1.business_group_id = p_business_group_id
1520: AND hoi1.organization_id = o1.organization_id