APPS.AMS_DELIVERABLE_PVT dependencies on AMS_DELIV_KIT_ITEMS

Line 2855: from ams_deliv_kit_items

2851:
2852: -- Check if this deliverable is a kit
2853: CURSOR is_deliv_kit(l_deliverable_id IN NUMBER )
2854: IS select count(*)
2855: from ams_deliv_kit_items
2856: where deliverable_kit_id = l_deliverable_id;
2857:
2858: -- Check if this deliverable is part of a kit
2859: CURSOR is_deliv_kit_part(l_deliverable_id IN NUMBER )

Line 2861: from ams_deliv_kit_items

2857:
2858: -- Check if this deliverable is part of a kit
2859: CURSOR is_deliv_kit_part(l_deliverable_id IN NUMBER )
2860: IS select count(*)
2861: from ams_deliv_kit_items
2862: where deliverable_kit_part_id = l_deliverable_id;
2863:
2864: l_kits_check NUMBER;
2865: l_qp_profile varchar2(1) := FND_PROFILE.Value('AMS_QP_PRICING_CALLOUT');