APPS.GMF_GMFLCHST_XMLP_PKG dependencies on GMF_LC_ADJ_TRANSACTIONS

Line 250: FROM gmf_lc_adj_transactions glat,

246: --LCM-OPM Integration, bug 8642337
247: CURSOR cur_lc_det (l_adj_transaction_id NUMBER)
248: IS
249: SELECT rsh.receipt_num, glat.lc_ship_num
250: FROM gmf_lc_adj_transactions glat,
251: rcv_transactions rt,
252: rcv_shipment_headers rsh
253: WHERE glat.rcv_transaction_id = rt.transaction_id
254: AND rsh.shipment_header_id = rt.shipment_header_id

Line 258: l_lc_ship_num gmf_lc_adj_transactions.lc_ship_num%TYPE;

254: AND rsh.shipment_header_id = rt.shipment_header_id
255: AND glat.adj_transaction_id = l_adj_transaction_id ;
256:
257: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
258: l_lc_ship_num gmf_lc_adj_transactions.lc_ship_num%TYPE;
259:
260: BEGIN
261: IF (DOC_TYPE = 'PROD') THEN
262: OPEN CUR_GET_BTCH;