DBA Data[Home] [Help]

APPS.AMS_APPROVAL_UTIL_PVT dependencies on AMS_EVENT_OFFERS_VL

Line 126: FROM ams_event_offers_vl A, ams_event_headers_vl B

122: AND A.schedule_id = l_activity_id;
123: ELSIF l_activity_type = 'EVEO' THEN
124: OPEN l_owner_details FOR
125: SELECT B.owner_user_id
126: FROM ams_event_offers_vl A, ams_event_headers_vl B
127: WHERE B.event_header_id = A.event_header_id
128: AND A.event_offer_id = l_activity_id;
129: ELSIF l_activity_type = 'OFFR' THEN
130: OPEN l_owner_details FOR