DBA Data[Home] [Help]

APPS.AMS_PRETTY_URL_PVT dependencies on AMS_CAMPAIGN_SCHEDULES_VL

Line 94: ams_campaign_schedules_vl sched,

90: CURSOR c_is_sysUrl_unique IS
91: SELECT sched.schedule_name, res.full_name
92: FROM ams_pretty_url_assoc assoc,
93: ams_system_pretty_url sysUrl,
94: ams_campaign_schedules_vl sched,
95: ams_jtf_rs_emp_v res
96: WHERE sysUrl.system_url = p_sys_url
97: AND sysUrl.system_url_id = assoc.system_url_id
98: AND assoc.used_by_obj_Id <> p_current_used_by_id