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_FI_PRC_DISC_SUA dependencies on HZ_PARTIES

Line 122: FROM hz_parties

118:
119: -- Cursor for validating the Person Id
120: CURSOR cur_person_id(cp_person_id IN igs_pe_person.person_id%TYPE) IS
121: SELECT party_number
122: FROM hz_parties
123: WHERE party_id = cp_person_id;
124:
125: -- Cursor for validation of the Person Id Group
126: CURSOR cur_person_id_group(cp_person_id_grp IN NUMBER) IS

Line 335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,

331: -- Cursor for getting the details for the charges for the person which have the Amount Due as greater than zero
332: -- and which have been created due to the Fee Assessment Run and have the Unit Section details
333: -- and the records do not have waiver details
334:
335: CURSOR cur_person_chrgs(cp_n_person_id IN hz_parties.party_id%type,
336: cp_v_balance_type IN igs_fi_balance_rules.balance_name%TYPE,
337: cp_v_fee_cal_type IN igs_fi_inv_int_all.fee_cal_type%TYPE,
338: cp_n_fee_ci_sequence_number IN igs_fi_inv_int_all.fee_ci_sequence_number%TYPE
339: ) IS