353: ,hoi.org_information9
354: ,hoi.org_information10
355: ,hoi.org_information11
356: ,hoi.org_information12
357: FROM hr_organization_information hoi
358: WHERE hoi.organization_id = c_work_center
359: AND hoi.org_information_context = 'ES_WORK_CENTER_DETAILS';
360: --
361: BEGIN
405: ,c_period_end_date DATE)IS
406: SELECT hoi2.org_information1 situation
407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
406: SELECT hoi2.org_information1 situation
407: ,fnd_date.canonical_to_date(hoi2.org_information2) start_date
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
414: AND hoi.org_information1 = c_work_center
408: ,nvl(fnd_date.canonical_to_date(hoi2.org_information3),c_period_end_date) end_date
409: FROM hr_organization_information hoi
410: ,hr_organization_information hoi1
411: ,hr_all_organization_units hou
412: ,hr_organization_information hoi2
413: WHERE hou.business_group_id = p_business_gr_id
414: AND hoi.org_information1 = c_work_center
415: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
416: AND hoi1.organization_id = hou.organization_id
711: */
712: --
713: CURSOR get_legal_employer_id(c_work_center_id NUMBER) IS
714: SELECT hoi.organization_id
715: FROM hr_organization_information hoi
716: WHERE hoi.org_information1 = c_work_center_id
717: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
718: --
719: l_def_bal_id NUMBER;
1088: ,c_period_end_date DATE) IS
1089: SELECT fnd_date.canonical_to_date(hoi.org_information1) Information_1
1090: ,nvl(fnd_date.canonical_to_date(hoi.org_information2),c_period_end_date) Information_2
1091: ,hoi.org_information3 Information_3
1092: FROM hr_organization_information hoi
1093: WHERE hoi.organization_id = c_work_center
1094: AND hoi.org_information_context = c_context --'ES_WC_PARTIAL_UNEMPLOYMENT'~~'ES_WC_NATURAL_DISASTER'
1095: ORDER BY 1;
1096: --
1664: */
1665: --
1666: CURSOR get_legal_employer_id(c_work_center_id NUMBER) IS
1667: SELECT hoi.organization_id
1668: FROM hr_organization_information hoi
1669: WHERE hoi.org_information1 = c_work_center_id
1670: AND hoi.org_information_context = 'ES_WORK_CENTER_REF';
1671: --
1672: l_def_bal_id NUMBER;