APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on HR_LOCATIONS_ALL

Line 20: Cursor C_Vend_Id(p_po_id number) IS SELECT a. Vendor_id, a.ship_to_location_id, b.location_code FROM po_headers_all a, hr_locations_all b

16: Cursor C_Reg_Sel IS SELECT register_selected, po_id
17: FROM JAI_OPM_OSP_HDRS
18: WHERE osp_header_id = pr_new.batch_id ;
19:
20: Cursor C_Vend_Id(p_po_id number) IS SELECT a. Vendor_id, a.ship_to_location_id, b.location_code FROM po_headers_all a, hr_locations_all b
21: WHERE po_header_id = p_po_id
22: AND a.SHIP_TO_LOCATION_ID = b.LOCATION_ID; /*Added ship_to_location_id for bug # 9088563*/
23:
24: Cursor C_Osp_Rcpt_Dtl IS