DBA Data[Home] [Help]

APPS.OE_GSA_UTIL dependencies on OE_PRICE_BREAK_LINES

Line 321: OE_PRICE_BREAK_LINES OEPBL

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
325: BETWEEN NVL(OEDIS.START_DATE_ACTIVE,l_pricing_date)

Line 423: OE_PRICE_BREAK_LINES OEPBL

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
427: BETWEEN NVL(OEDIS.START_DATE_ACTIVE,l_pricing_date)