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.CS_SR_TASK_AUTOASSIGN_PKG dependencies on HZ_CONTACT_POINTS

Line 444: FROM hz_contact_points hzp

440:
441: --Bug 5255184 Modified the c_area_code query
442: CURSOR c_area_code IS
443: SELECT hzp.phone_area_code
444: FROM hz_contact_points hzp
445: WHERE hzp.contact_point_id = c_customer_phone_id;
446:
447: BEGIN
448: -- Initialize API return status to success

Line 652: FROM hz_contact_points hzp,

648: WHERE cle_id = l_contract_service_id;
649:
650: CURSOR c_area_code(c_incident_id NUMBER) IS
651: SELECT hzp.phone_area_code
652: FROM hz_contact_points hzp,
653: cs_incidents_all_b csi
654: WHERE csi.incident_id = c_incident_id
655: AND csi.customer_phone_id = hzp.contact_point_id
656: AND csi.customer_phone_id IS NOT NULL;