DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_PKG dependencies on HZ_CONTACT_POINTS

Line 538: FROM hz_contact_points hzp

534: */
535: --Bug 5255184 Modified the c_area_code query
536: CURSOR c_area_code IS
537: SELECT hzp.phone_area_code
538: FROM hz_contact_points hzp
539: WHERE hzp.contact_point_id = c_customer_phone_id;
540:
541: CURSOR c_cust_det(p_customer_id NUMBER) IS
542: SELECT employees_total, party_name

Line 960: FROM hz_contact_points hzp

956: */
957: --Bug 5255184 Modified the c_area_code query
958: CURSOR c_area_code IS
959: SELECT hzp.phone_area_code
960: FROM hz_contact_points hzp
961: WHERE hzp.contact_point_id = c_customer_phone_id;
962:
963: CURSOR c_check_grp_res(p_group_id NUMBER, p_resource_id NUMBER) IS
964: SELECT 'Y'