APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_PAYMENT_TYPES_ALL

Line 1330: FROM oe_payment_types_all pt

1326: AND T.TERM_ID = L.PAYMENT_TERM_ID
1327: AND NVL(T.CREDIT_CHECK_FLAG,'N') = 'Y' --bug4888346
1328: AND (EXISTS
1329: (SELECT NULL
1330: FROM oe_payment_types_all pt
1331: WHERE pt.payment_type_code = NVL(l.payment_type_code,
1332: NVL(h.payment_type_code, 'BME'))
1333: AND pt.credit_check_flag = 'Y'
1334: AND NVL(pt.org_id, -99) = NVL(l.org_id,-99))