DBA Data[Home] [Help]

APPS.AMS_PRETTY_URL_PVT dependencies on AMS_JTF_RS_EMP_V

Line 95: ams_jtf_rs_emp_v res

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
99: AND sched.SCHEDULE_ID = assoc.used_by_obj_id