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

Line 130: CURSOR c_get_person_number IS SELECT party_number FROM hz_parties

126: Known limitations,enhancements,remarks:
127: Change History
128: Who When What
129: *****************************************************************************************/
130: CURSOR c_get_person_number IS SELECT party_number FROM hz_parties
131: WHERE party_id = p_pid;
132: l_person_number hz_parties.party_number%TYPE;
133: l_err_msg VARCHAR2(2000);
134: BEGIN

Line 132: l_person_number hz_parties.party_number%TYPE;

128: Who When What
129: *****************************************************************************************/
130: CURSOR c_get_person_number IS SELECT party_number FROM hz_parties
131: WHERE party_id = p_pid;
132: l_person_number hz_parties.party_number%TYPE;
133: l_err_msg VARCHAR2(2000);
134: BEGIN
135: OPEN c_get_person_number ;
136: FETCH c_get_person_number INTO l_person_number;