APPS.OE_CREDIT_PUB dependencies on OE_RA_TERMS_V

Line 649: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

645: BEGIN
646:
647: SELECT COUNT(*)
648: INTO l_credit_check_term
649: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
650: WHERE L.HEADER_ID = p_header_rec.header_id
651: AND T.TERM_ID = L.PAYMENT_TERM_ID
652: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';
653:

Line 2329: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

2325: BEGIN
2326:
2327: SELECT COUNT(*)
2328: INTO l_credit_check_term
2329: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
2330: WHERE L.header_id = p_header_rec.header_id
2331: AND L.invoice_to_org_id = p_invoice_to_org_id
2332: AND L.PAYMENT_TERM_ID = T.TERM_ID
2333: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';