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, 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

Line 61: l_location_id po_headers_all.ship_to_location_id%TYPE; /* Bug#9088563 */

57: l_tot_excise_payable Number;
58: l_recv_qty Number;
59: l_location_code Varchar2(4);
60: return_days number;
61: l_location_id po_headers_all.ship_to_location_id%TYPE; /* Bug#9088563 */
62:
63: /* Added by Ramananda for removal of SQL LITERALs */
64: lv_register JAI_OPM_OSP_HDRS.REGISTER_SELECTED%type ;
65: lv_tran_name JAI_OPM_TXN_EXTN_HDRS.transaction_name%type ;