APPS.AMS_APPROVAL_UTIL_PVT dependencies on AMS_ACT_OFFERS

Line 132: FROM ams_act_offers A, ams_campaigns_vl B

128: AND A.event_offer_id = l_activity_id;
129: ELSIF l_activity_type = 'OFFR' THEN
130: OPEN l_owner_details FOR
131: SELECT B.owner_user_id
132: FROM ams_act_offers A, ams_campaigns_vl B
133: WHERE B.campaign_id = A.act_offer_used_by_id
134: AND A.arc_act_offer_used_by = 'CAMP'
135: AND A.qp_list_header_id = l_activity_id;
136: END IF;