APPS.OE_BULK_TAX_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 666: FROM HR_ALL_ORGANIZATION_UNITS

662: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
663: BEGIN
664: SELECT location_id
665: INTO l_bill_from_location_id
666: FROM HR_ALL_ORGANIZATION_UNITS
667: WHERE organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);
668: EXCEPTION
669: WHEN OTHERS THEN
670: l_bill_from_location_id := NULL;

Line 776: FROM hr_all_organization_units hu

772: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
773: BEGIN
774: SELECT location_id
775: INTO l_ship_from_location_id
776: FROM hr_all_organization_units hu
777: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);
778: EXCEPTION
779: WHEN OTHERS THEN
780: NULL;

Line 942: FROM hr_all_organization_units hu

938: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
939: BEGIN
940: SELECT location_id
941: INTO l_ship_from_location_id
942: FROM hr_all_organization_units hu
943: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);
944: EXCEPTION
945: WHEN OTHERS THEN
946: NULL;

Line 1095: FROM hr_all_organization_units hu

1091: IF OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1092: BEGIN
1093: SELECT location_id
1094: INTO l_ship_from_location_id
1095: FROM hr_all_organization_units hu
1096: WHERE hu.organization_id = OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index);
1097: EXCEPTION
1098: WHEN OTHERS THEN
1099: NULL;