eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_SR_CONTACT_EVENT_PKG dependencies on HZ_CONTACT_POINTS

Line 225: l_contact_point_id hz_contact_points.contact_point_id%TYPE;

221: l_sqlerrno VARCHAR2(20);
222: l_sqlerrmsg VARCHAR2(4000);
223: l_error_msg VARCHAR2(4000);
224: l_return_status VARCHAR2(2000);
225: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
226:
227: CURSOR l_user_csr (p_contact_point_id hz_contact_points.contact_point_id%TYPE)
228: IS
229: SELECT acc.user_id,

Line 227: CURSOR l_user_csr (p_contact_point_id hz_contact_points.contact_point_id%TYPE)

223: l_error_msg VARCHAR2(4000);
224: l_return_status VARCHAR2(2000);
225: l_contact_point_id hz_contact_points.contact_point_id%TYPE;
226:
227: CURSOR l_user_csr (p_contact_point_id hz_contact_points.contact_point_id%TYPE)
228: IS
229: SELECT acc.user_id,
230: acc.access_id
231: FROM csm_sr_contacts_acc acc,