APPS.IBE_QUOTE_MISC_PVT dependencies on IBE_DSP_MSITE_SCT_ITEMS

Line 2419: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

2415: l_inventory_item_id := to_number(l_attribute_value);
2416: --inv_debug.message('ssia', 'l_inventory_item_id is ' || l_inventory_item_id);
2417: select count(s.inventory_item_id)
2418: into l_item_exists
2419: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
2420: where s.section_item_id = b.section_item_id
2421: and b.mini_site_id = p_minisite_id
2422: and s.inventory_item_id = l_inventory_item_id
2423: and (s.end_date_active > sysdate or s.end_date_active is null )

Line 2539: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

2535: l_inventory_item_id := x_inventory_item_id_tbl(i);
2536: --inv_debug.message('ssia', 'l_inventory_item_id is ' || l_inventory_item_id);
2537: select count(s.inventory_item_id)
2538: into l_item_exists
2539: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
2540: where s.section_item_id = b.section_item_id
2541: and b.mini_site_id = p_minisite_id
2542: and s.inventory_item_id = l_inventory_item_id
2543: and (s.end_date_active > sysdate or s.end_date_active is null )

Line 3320: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b

3316: IF p_merchant_item_ids(i) IS NOT NULL THEN
3317: --inv_debug.message('ssia', 'p_cust_item_number is ' || p_cust_item_number_tbl(i));
3318: select count(s.inventory_item_id)
3319: into l_item_exists
3320: from ibe_dsp_section_items s, ibe_dsp_msite_sct_items b
3321: where s.section_item_id = b.section_item_id
3322: and b.mini_site_id = p_minisite_id
3323: and s.inventory_item_id = p_merchant_item_ids(i)
3324: and (s.end_date_active > sysdate or s.end_date_active is null )