[Home] [Help]
1285: WHERE header_id=p_x_header_Payment_rec.header_id;
1286:
1287: IF p_old_header_payment_rec.payment_type_code IS NOT NULL THEN
1288: SELECT credit_check_flag INTO l_cc_flag_old
1289: FROM oe_payment_types_vl
1290: WHERE payment_type_code=p_old_Header_Payment_rec.payment_type_code;
1291: END IF;
1292:
1293: SELECT credit_check_flag INTO l_cc_flag_new
1290: WHERE payment_type_code=p_old_Header_Payment_rec.payment_type_code;
1291: END IF;
1292:
1293: SELECT credit_check_flag INTO l_cc_flag_new
1294: FROM oe_payment_types_vl
1295: WHERE payment_type_code=p_x_Header_Payment_rec.payment_type_code;
1296:
1297: IF l_booked_flag = 'Y' AND
1298: NOT OE_GLOBALS.Equal(l_cc_flag_old,l_cc_flag_new)