DBA Data[Home] [Help]

APPS.AMS_APPROVAL_UTIL_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_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