DBA Data[Home] [Help]

APPS.AMS_PRETTY_URL_PVT dependencies on AMS_PRETTY_URL_ASSOC

Line 92: FROM ams_pretty_url_assoc assoc,

88: WHERE schedule_id = p_current_used_by_id;
89:
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