APPS.OE_CREDIT_PUB dependencies on OE_RA_TERMS_V

Line 631: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

627: BEGIN
628:
629: SELECT COUNT(*)
630: INTO l_credit_check_term
631: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
632: WHERE L.HEADER_ID = p_header_rec.header_id
633: AND T.TERM_ID = L.PAYMENT_TERM_ID
634: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';
635:

Line 2293: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T

2289: BEGIN
2290:
2291: SELECT COUNT(*)
2292: INTO l_credit_check_term
2293: FROM OE_ORDER_LINES L, OE_RA_TERMS_V T
2294: WHERE L.header_id = p_header_rec.header_id
2295: AND L.invoice_to_org_id = p_invoice_to_org_id
2296: AND L.PAYMENT_TERM_ID = T.TERM_ID
2297: AND NVL(T.CREDIT_CHECK_FLAG, 'Y') = 'Y';