APPS.JTF_DSP_SECTION_ITEM_PVT dependencies on JTF_DSP_MSITE_SCT_ITEMS

Line 1027: IS SELECT mini_site_section_item_id FROM jtf_dsp_msite_sct_items

1023: l_inventory_item_id NUMBER;
1024: l_organization_id NUMBER;
1025:
1026: CURSOR c1(l_c_section_item_id IN NUMBER)
1027: IS SELECT mini_site_section_item_id FROM jtf_dsp_msite_sct_items
1028: WHERE section_item_id = l_c_section_item_id;
1029:
1030: CURSOR c2(l_c_section_item_id IN NUMBER)
1031: IS SELECT section_id, inventory_item_id, organization_id

Line 1130: -- delete from jtf_dsp_msite_sct_items table

1126: FND_MSG_PUB.Add;
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: -- delete from jtf_dsp_msite_sct_items table
1131: FOR r1 IN c1(l_section_item_id) LOOP
1132:
1133: JTF_DSP_MSITE_SCT_ITEM_PVT.Delete_MSite_Section_Item
1134: (