APPS.AMS_APPROVAL_UTIL_PVT dependencies on AMS_CAMPAIGNS_VL

Line 120: FROM ams_campaign_schedules_vl A, ams_campaigns_vl B

116:
117: IF l_activity_type = 'CSCH' THEN
118: OPEN l_owner_details FOR
119: SELECT B.owner_user_id
120: FROM ams_campaign_schedules_vl A, ams_campaigns_vl B
121: WHERE B.campaign_id = A.campaign_id
122: AND A.schedule_id = l_activity_id;
123: ELSIF l_activity_type = 'EVEO' THEN
124: OPEN l_owner_details FOR

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;