APPS.JAI_OPM_GBH_TRIGGER_PKG dependencies on PO_HEADERS_ALL

Line 20: Cursor C_Vend_Id(p_po_id number) IS SELECT a. Vendor_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, 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;
23:
24: Cursor C_Osp_Rcpt_Dtl IS