APPS.PO_SHARED_PROC_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 568: l_pou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;

564: l_item_valid_status VARCHAR2(1);
565: l_item_valid_msg_name FND_NEW_MESSAGES.message_name%TYPE;
566: x_app_name VARCHAR2(10);
567: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
568: l_pou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
569: l_rou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
570: l_item_in_linv_pou VARCHAR2(1) := 'Y'; -- Bug 3433867
571:
572: BEGIN

Line 569: l_rou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;

565: l_item_valid_msg_name FND_NEW_MESSAGES.message_name%TYPE;
566: x_app_name VARCHAR2(10);
567: l_purchase_basis PO_REQUISITION_LINES_ALL.purchase_basis%TYPE;
568: l_pou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
569: l_rou_bus_group_id HR_ALL_ORGANIZATION_UNITS.business_group_id%TYPE;
570: l_item_in_linv_pou VARCHAR2(1) := 'Y'; -- Bug 3433867
571:
572: BEGIN
573:

Line 826: hr_all_organization_units hrou_po,

822: INTO l_purchase_basis,
823: l_pou_bus_group_id,
824: l_rou_bus_group_id
825: FROM po_requisition_lines_all prl,
826: hr_all_organization_units hrou_po,
827: hr_all_organization_units hrou_req
828: WHERE prl.requisition_line_id = p_requisition_line_id
829: AND hrou_po.organization_id = p_purchasing_org_id
830: AND hrou_req.organization_id = p_requesting_org_id;

Line 827: hr_all_organization_units hrou_req

823: l_pou_bus_group_id,
824: l_rou_bus_group_id
825: FROM po_requisition_lines_all prl,
826: hr_all_organization_units hrou_po,
827: hr_all_organization_units hrou_req
828: WHERE prl.requisition_line_id = p_requisition_line_id
829: AND hrou_po.organization_id = p_purchasing_org_id
830: AND hrou_req.organization_id = p_requesting_org_id;
831: