DBA Data[Home] [Help]

APPS.CSC_RESPONSE_CENTER_PKG dependencies on HZ_CONTACT_POINTS

Line 280: FROM hz_contact_points ph, ar_lookups lkup

276: INTO l_phone_country_code, l_phone_area_code, l_phone_number,
277: l_phone_line_type, l_phone_line_code,
278: l_phone_id, l_phone_object_version_number, l_phone_extension,
279: l_full_phone
280: FROM hz_contact_points ph, ar_lookups lkup
281: WHERE ph.phone_line_type = lkup.lookup_code
282: AND lkup.lookup_type = 'PHONE_LINE_TYPE'
283: AND lkup.enabled_flag = 'Y'
284: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(lkup.start_date_active, SYSDATE))