DBA Data[Home] [Help]

APPS.DDR_EMD_UTIL dependencies on DDR_R_ITEM_BSNS_UNT_ASSC

Line 155: FROM ddr_r_item_bsns_unt_assc

151: v_rec_count NUMBER:= 0;
152:
153: CURSOR new_items IS
154: SELECT *
155: FROM ddr_r_item_bsns_unt_assc
156: WHERE eff_from_dt > TRUNC(p_date) - ddr_emd_util.new_item_period
157: AND rtl_org_cd = NVL(p_rtl_org_cd,rtl_org_cd)
158: AND rtl_bsns_unit_id = NVL(p_bsns_unit_id,rtl_bsns_unit_id)
159: AND mfg_sku_item_id = NVL(p_mfg_sku_item_id,mfg_sku_item_id)