APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on HZ_CONTACT_POINTS

Line 452: FROM hz_contact_points hzp

448:
449: /*--Bug 5255184 Modified the c_area_code query
450: CURSOR c_area_code IS
451: SELECT hzp.phone_area_code
452: FROM hz_contact_points hzp
453: WHERE hzp.contact_point_id = c_customer_phone_id;*/
454:
455: -- bug 14156822
456: CURSOR c_area_code(c_incident_id NUMBER) IS

Line 458: FROM hz_contact_points hzp,

454:
455: -- bug 14156822
456: CURSOR c_area_code(c_incident_id NUMBER) IS
457: SELECT hzp.phone_area_code
458: FROM hz_contact_points hzp,
459: cs_incidents_all_b csi
460: WHERE csi.incident_id = c_incident_id
461: AND csi.customer_phone_id = hzp.contact_point_id
462: AND csi.customer_phone_id IS NOT NULL;

Line 718: FROM hz_contact_points hzp,

714: WHERE cle_id = l_contract_service_id;
715:
716: CURSOR c_area_code(c_incident_id NUMBER) IS
717: SELECT hzp.phone_area_code
718: FROM hz_contact_points hzp,
719: cs_incidents_all_b csi
720: WHERE csi.incident_id = c_incident_id
721: AND csi.customer_phone_id = hzp.contact_point_id
722: AND csi.customer_phone_id IS NOT NULL;