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_PS_RSV_ORGUN_PRF_PKG dependencies on IGS_PE_HZ_PARTIES

Line 119: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe

115:
116:
117: PROCEDURE check_parent_existance AS
118: CURSOR c_check_hz_exists IS
119: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe
120: WHERE hp.party_id = pe.party_id
121: AND pe.oss_org_unit_cd = new_references.preference_code;
122: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
123:

Line 137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in

133: || Purpose : Checks for the existance of Parent records.
134: || Known limitations, enhancements or remarks :
135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */

Line 138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES

134: || Known limitations, enhancements or remarks :
135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */
142: BEGIN

Line 139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.

135: || Change History :
136: || Who When What
137: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
138: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
139: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
140: || (reverse chronological order - newest change first)
141: */
142: BEGIN
143: