APPS.OZF_TP_UTIL_QUERIES dependencies on AMS_CAMPAIGNS_ALL_TL

Line 346: FROM ams_campaigns_all_tl

342: AND language = userenv('LANG');
343: elsif activity_class = 'CAMP' OR activity_class = 'ECAM' OR activity_class = 'TRDP' then
344: SELECT campaign_name
345: INTO x_return_value
346: FROM ams_campaigns_all_tl
347: WHERE campaign_id = activity_id
348: AND language = userenv('LANG');
349: end if;
350: