DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on HR_LOCATIONS

Line 925: FROM Hr_Locations

921:
922: -- Start, Vijay Shankar for Bug# 3193592
923: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
924: SELECT Inventory_Organization_Id
925: FROM Hr_Locations
926: WHERE Location_Id = p_ship_to_location_id;
927:
928: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
929: v_line_loc_cnt NUMBER;

Line 928: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;

924: SELECT Inventory_Organization_Id
925: FROM Hr_Locations
926: WHERE Location_Id = p_ship_to_location_id;
927:
928: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
929: v_line_loc_cnt NUMBER;
930: v_ship_to_organization_id NUMBER;
931: v_ship_to_location_id NUMBER;
932: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;