DBA Data[Home] [Help]

APPS.GML_SYNCH_BPOS dependencies on OP_TERM_MST

Line 296: CURSOR terms_code_cur (p_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS

292: WHERE of_fob_code = p_of_fob_code;
293:
294: /* Cursor to select terms_code */
295:
296: CURSOR terms_code_cur (p_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS
297: SELECT terms_code
298: FROM op_term_mst
299: WHERE of_terms_code = p_of_terms_code;
300:

Line 298: FROM op_term_mst

294: /* Cursor to select terms_code */
295:
296: CURSOR terms_code_cur (p_of_terms_code OP_TERM_MST.OF_TERMS_CODE%TYPE) IS
297: SELECT terms_code
298: FROM op_term_mst
299: WHERE of_terms_code = p_of_terms_code;
300:
301: /* Cursor to select bpo_id */
302:

Line 353: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;

349: v_item_desc IC_ITEM_MST.ITEM_DESC1%TYPE;
350: v_ship_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
351: v_pay_vendor_id PO_VEND_MST.VENDOR_ID%TYPE;
352: v_fob_code OP_FOBC_MST.FOB_CODE%TYPE;
353: v_terms_code OP_TERM_MST.TERMS_CODE%TYPE;
354:
355: v_exchange_rate GL_XCHG_RTE.EXCHANGE_RATE%TYPE;
356: v_mul_div_sign GL_XCHG_RTE.MUL_DIV_SIGN%TYPE;
357: v_exchange_rate_date GL_XCHG_RTE.EXCHANGE_RATE_DATE%TYPE;