DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on HZ_CONTACT_POINTS

Line 703: FROM hz_contact_points hzp

699:
700: --Bug 5255184 Modified the c_area_code query
701: CURSOR c_area_code IS
702: SELECT hzp.phone_area_code
703: FROM hz_contact_points hzp
704: WHERE hzp.contact_point_id = c_customer_phone_id;
705:
706: CURSOR c_cust_det(p_customer_id NUMBER) IS
707: SELECT employees_total, party_name

Line 1030: FROM hz_contact_points hzp

1026: -- Added in 11.5.9. Fetch phone area code for the customer.
1027: --Bug 5255184 Modified the c_area_code query
1028: CURSOR c_area_code IS
1029: SELECT hzp.phone_area_code
1030: FROM hz_contact_points hzp
1031: WHERE hzp.contact_point_id = c_customer_phone_id;
1032:
1033: -- Added for member filtering for IB/Contracts Preferred Resources
1034: -- From 11.5.10 onwards