eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_HZ_CONTACT_POINT_PKG dependencies on HZ_CONTACT_POINTS

Line 23: FROM hz_contact_points

19: IS
20: CURSOR l_cur IS
21: SELECT contact_point_id, object_version_number,
22: phone_number, phone_area_code, phone_extension
23: FROM hz_contact_points
24: WHERE owner_table_name = p_owner_table_name
25: AND owner_table_id = p_owner_table_id
26: AND contact_point_type = 'PHONE'
27: AND phone_line_type = 'GEN'

Line 166: FROM hz_contact_points

162: IS
163: CURSOR l_cur IS
164: SELECT contact_point_id, object_version_number, phone_number,
165: phone_area_code, phone_extension
166: FROM hz_contact_points
167: WHERE owner_table_name = p_owner_table_name
168: AND owner_table_id = p_owner_table_id
169: AND contact_point_type = 'PHONE'
170: AND phone_line_type = 'FAX'

Line 284: FROM hz_contact_points

280: )
281: IS
282: CURSOR l_cur IS
283: SELECT contact_point_id, object_version_number, email_address
284: FROM hz_contact_points
285: WHERE owner_table_name = p_owner_table_name
286: AND owner_table_id = p_owner_table_id
287: AND contact_point_type = 'EMAIL'
288: AND primary_flag = 'Y'