APPS.IGS_PS_RSV_OGPRI_PKG dependencies on IGS_PE_HZ_PARTIES

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

104: || Purpose : Checks for the existance of Parent records.
105: || Known limitations, enhancements or remarks :
106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */

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

105: || Known limitations, enhancements or remarks :
106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */
113: CURSOR c_check_hz_exists

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

106: || Change History :
107: || Who When What
108: || sommukhe 12-AUG-2005 Bug#4377818,changed the cursor c_check_hz_exists, included table igs_pe_hz_parties in
109: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
110: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
111: || (reverse chronological order - newest change first)
112: */
113: CURSOR c_check_hz_exists
114: is

Line 118: hz_parties hp,igs_pe_hz_parties pe

114: is
115: SELECT
116: 'x'
117: FROM
118: hz_parties hp,igs_pe_hz_parties pe
119: WHERE
120: hp.party_id = pe.party_id
121: AND pe.oss_org_unit_cd =new_references.org_unit_cd;
122: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;