DBA Data[Home] [Help]

APPS.OE_GSA_UTIL dependencies on OE_DISCOUNTS

Line 318: FROM OE_DISCOUNTS OEDIS,

314: END IF;
315:
316: SELECT count(*)
317: INTO l_gsa_count
318: FROM OE_DISCOUNTS OEDIS,
319: OE_DISCOUNT_CUSTOMERS OEDCU,
320: OE_DISCOUNT_LINES OEDLN,
321: OE_PRICE_BREAK_LINES OEPBL
322: WHERE OEDIS.GSA_INDICATOR = 'Y'

Line 420: FROM OE_DISCOUNTS OEDIS,

416: l_pricing_date := p_line_rec.pricing_date;
417:
418: SELECT count(*)
419: INTO l_nongsa_count
420: FROM OE_DISCOUNTS OEDIS,
421: OE_DISCOUNT_CUSTOMERS OEDCU,
422: OE_DISCOUNT_LINES OEDLN,
423: OE_PRICE_BREAK_LINES OEPBL
424: WHERE OEDIS.GSA_INDICATOR = 'N'