APPS.GML_PO_GLDIST dependencies on PO_VEND_MST

Line 451: CURSOR Cur_po_vend_mst IS

447: SELECT noninv_ind,gl_class
448: FROM ic_item_mst
449: WHERE item_id = V_gl_item_id;
450:
451: CURSOR Cur_po_vend_mst IS
452: SELECT vendgl_class gl_vendorgl_class
453: FROM po_vend_mst
454: WHERE vendor_id = V_shipvend_id;
455:

Line 453: FROM po_vend_mst

449: WHERE item_id = V_gl_item_id;
450:
451: CURSOR Cur_po_vend_mst IS
452: SELECT vendgl_class gl_vendorgl_class
453: FROM po_vend_mst
454: WHERE vendor_id = V_shipvend_id;
455:
456: CURSOR Cur_po_cost_mst IS
457: SELECT cmpntcls_id , analysis_code

Line 624: OPEN Cur_po_vend_mst;

620: FETCH Cur_item_mst INTO P_non_inv_ind, P_itemglclass;
621: CLOSE Cur_item_mst;
622:
623: /* Added select of vendor gl_class to be passed to mapping*/
624: OPEN Cur_po_vend_mst;
625: FETCH Cur_po_vend_mst INTO P_vend_gl_class;
626: CLOSE Cur_po_vend_mst;
627:
628: IF V_Single_aqui = TRUE THEN

Line 625: FETCH Cur_po_vend_mst INTO P_vend_gl_class;

621: CLOSE Cur_item_mst;
622:
623: /* Added select of vendor gl_class to be passed to mapping*/
624: OPEN Cur_po_vend_mst;
625: FETCH Cur_po_vend_mst INTO P_vend_gl_class;
626: CLOSE Cur_po_vend_mst;
627:
628: IF V_Single_aqui = TRUE THEN
629: GML_PO_GLDIST.poglded2_check_new_aqui(retcode) ;

Line 626: CLOSE Cur_po_vend_mst;

622:
623: /* Added select of vendor gl_class to be passed to mapping*/
624: OPEN Cur_po_vend_mst;
625: FETCH Cur_po_vend_mst INTO P_vend_gl_class;
626: CLOSE Cur_po_vend_mst;
627:
628: IF V_Single_aqui = TRUE THEN
629: GML_PO_GLDIST.poglded2_check_new_aqui(retcode) ;
630: ELSE