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;