DBA Data[Home] [Help]

APPS.DDR_EMD_UTIL dependencies on DDR_B_PRMTN_PLN

Line 407: FROM ddr_b_prmtn_pln

403: ,x_msg OUT NOCOPY VARCHAR2
404: ) IS
405: CURSOR c1 IS
406: SELECT MIN(prmtn_price_amt_rpt) min_prmtn_price
407: FROM ddr_b_prmtn_pln
408: WHERE org_bsns_unit_id = p_sls_rec.org_bsns_unit_id
409: AND mfg_sku_item_id = p_sls_rec.mfg_sku_item_id
410: AND rtl_sku_item_id = p_sls_rec.rtl_sku_item_id
411: AND TO_DATE(p_sls_rec.day_cd,'YYYYMMDD') BETWEEN prmtn_from_dt AND prmtn_to_dt;