APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIV_KIT_ITEMS

Line 2868: from ams_deliv_kit_items

2864:
2865: -- Check if this deliverable is a kit
2866: CURSOR is_deliv_kit(l_deliverable_id IN NUMBER )
2867: IS select count(*)
2868: from ams_deliv_kit_items
2869: where deliverable_kit_id = l_deliverable_id;
2870:
2871: -- Check if this deliverable is part of a kit
2872: CURSOR is_deliv_kit_part(l_deliverable_id IN NUMBER )

Line 2874: from ams_deliv_kit_items

2870:
2871: -- Check if this deliverable is part of a kit
2872: CURSOR is_deliv_kit_part(l_deliverable_id IN NUMBER )
2873: IS select count(*)
2874: from ams_deliv_kit_items
2875: where deliverable_kit_part_id = l_deliverable_id;
2876:
2877: l_kits_check NUMBER;
2878: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');