APPS.GML_PO_SYNCH dependencies on OP_TERM_MST

Line 1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;

1498: v_dualum_ind IC_ITEM_MST.DUALUM_IND%TYPE;
1499: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1500: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
1501: v_frtbill_mthd OP_FRGT_MTH.FRTBILL_MTHD%TYPE;
1502: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
1503: v_new_trans_id IC_TRAN_PND.TRANS_ID%TYPE;
1504: v_co_code SY_ORGN_MST.CO_CODE%TYPE;
1505: v_old_order_qty1 PO_ORDR_DTL.ORDER_QTY1%TYPE;
1506: v_old_order_qty2 PO_ORDR_DTL.ORDER_QTY2%TYPE;

Line 1577: CURSOR terms_code_cur(v_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS

1573: FROM po_vend_mst
1574: WHERE of_vendor_site_id = v_of_shipvend_site_id
1575: AND co_code = v_co_code;
1576:
1577: CURSOR terms_code_cur(v_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS
1578: SELECT terms_code
1579: FROM op_term_mst
1580: WHERE of_terms_code = v_of_terms_code;
1581: /* Liz Enstone 18/AUG/98 Add orgn_code parameter*/

Line 1579: FROM op_term_mst

1575: AND co_code = v_co_code;
1576:
1577: CURSOR terms_code_cur(v_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS
1578: SELECT terms_code
1579: FROM op_term_mst
1580: WHERE of_terms_code = v_of_terms_code;
1581: /* Liz Enstone 18/AUG/98 Add orgn_code parameter*/
1582: CURSOR po_id_cur(v_po_no PO_ORDR_HDR.PO_NO%TYPE,
1583: v_orgn_code int_rec.orgn_code%TYPE) IS