APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_CONTACT_POINTS

Line 526: FROM hz_contact_points hzp

522: */
523: --Bug 5255184 Modified the c_area_code query
524: CURSOR c_area_code IS
525: SELECT hzp.phone_area_code
526: FROM hz_contact_points hzp
527: WHERE hzp.contact_point_id = c_customer_phone_id;
528:
529: CURSOR c_cust_det(p_customer_id NUMBER) IS
530: SELECT employees_total, party_name

Line 853: FROM hz_contact_points hzp

849: */
850: --Bug 5255184 Modified the c_area_code query
851: CURSOR c_area_code IS
852: SELECT hzp.phone_area_code
853: FROM hz_contact_points hzp
854: WHERE hzp.contact_point_id = c_customer_phone_id;
855:
856: CURSOR c_check_grp_res(p_group_id NUMBER, p_resource_id NUMBER) IS
857: SELECT 'Y'