APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_SYSTEM_PRETTY_URL

Line 2008: FROM ams_system_pretty_url sysUrl,

2004:
2005: -- dbiswas added the following cursor on 26-may-2005 for pretty URL uniqueness in 11.5.10.RUP4
2006: CURSOR c_system_url (p_schedule_id IN NUMBER)IS
2007: SELECT system_url, pretty_url_id, ctd_id
2008: FROM ams_system_pretty_url sysUrl,
2009: ams_pretty_url_assoc assoc
2010: WHERE assoc.used_by_obj_type ='CSCH'
2011: AND assoc.used_by_obj_id = p_schedule_id
2012: AND assoc.system_url_id = sysUrl.system_url_id;