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.PQP_HRTCA_INTEGRATION dependencies on HZ_CONTACT_POINTS

Line 2849: FROM hz_contact_points hcp

2845: ,hcp.phone_number
2846: ,hcp.phone_extension
2847: ,hcp.primary_flag
2848: ,hcp.phone_line_type
2849: FROM hz_contact_points hcp
2850: WHERE hcp.contact_point_type = 'PHONE'
2851: AND hcp.status = 'A'
2852: AND hcp.owner_table_name = 'HZ_PARTIES'
2853: AND hcp.owner_table_id = c_party_id;

Line 2855: TYPE t_Phones IS TABLE OF hz_contact_points.phone_number%TYPE

2851: AND hcp.status = 'A'
2852: AND hcp.owner_table_name = 'HZ_PARTIES'
2853: AND hcp.owner_table_id = c_party_id;
2854:
2855: TYPE t_Phones IS TABLE OF hz_contact_points.phone_number%TYPE
2856: INDEX BY Binary_Integer;
2857: l_phone_rec t_Phones;
2858: l_phone_no hz_contact_points.phone_number%TYPE;
2859: l_Address_Mapping pqp_configuration_values%ROWTYPE;

Line 2858: l_phone_no hz_contact_points.phone_number%TYPE;

2854:
2855: TYPE t_Phones IS TABLE OF hz_contact_points.phone_number%TYPE
2856: INDEX BY Binary_Integer;
2857: l_phone_rec t_Phones;
2858: l_phone_no hz_contact_points.phone_number%TYPE;
2859: l_Address_Mapping pqp_configuration_values%ROWTYPE;
2860: l_LookUp_Mapping pqp_configuration_values%ROWTYPE;
2861: ph_count Number(5);
2862: