DBA Data[Home] [Help]

APPS.JAI_PO_RLA_TRIGGER_PKG dependencies on HR_LOCATIONS

Line 1012: FROM Hr_Locations

1008:
1009: -- Start, Vijay Shankar for Bug# 3193592
1010: CURSOR c_inventory_org_id(p_ship_to_location_id IN NUMBER) IS
1011: SELECT Inventory_Organization_Id
1012: FROM Hr_Locations
1013: WHERE Location_Id = p_ship_to_location_id;
1014:
1015: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
1016: v_line_loc_cnt NUMBER;

Line 1015: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;

1011: SELECT Inventory_Organization_Id
1012: FROM Hr_Locations
1013: WHERE Location_Id = p_ship_to_location_id;
1014:
1015: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
1016: v_line_loc_cnt NUMBER;
1017: v_ship_to_organization_id NUMBER;
1018: v_ship_to_location_id NUMBER;
1019: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;