DBA Data[Home] [Help]

APPS.OE_GSA_UTIL dependencies on OE_DISCOUNT_LINES

Line 320: OE_DISCOUNT_LINES OEDLN,

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'
323: AND OEDIS.PRICE_LIST_ID = l_price_list_id
324: AND l_pricing_date

Line 422: OE_DISCOUNT_LINES OEDLN,

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'
425: AND OEDIS.PRICE_LIST_ID = l_price_list_id
426: AND l_pricing_date