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.JTF_IH_PUB dependencies on HZ_PARTIES

Line 139: SELECT PARTY_TYPE INTO s_Party_Type FROM HZ_PARTIES WHERE PARTY_ID = p_Party_Id;

135: FUNCTION Get_Party_Type( p_Party_Id IN NUMBER
136: ) RETURN VARCHAR2 AS
137: s_Party_Type VARCHAR2(30) := NULL;
138: BEGIN
139: SELECT PARTY_TYPE INTO s_Party_Type FROM HZ_PARTIES WHERE PARTY_ID = p_Party_Id;
140: RETURN s_Party_Type;
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: RETURN NULL;

Line 624: FROM hz_parties

620: END;
621: ELSE
622: BEGIN
623: SELECT count(party_id) into l_count
624: FROM hz_parties
625: WHERE party_id = p_int_val_rec.resource_id;
626: IF (l_count <= 0) THEN
627: x_return_status := fnd_api.g_ret_sts_error;
628: jtf_ih_core_util_pvt.add_invalid_argument_msg(p_api_name, to_char(p_int_val_rec.resource_id),