APPS.IGS_PS_RSV_USEC_PRF_PKG dependencies on IGS_PE_HZ_PARTIES

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

102: END check_uniqueness;
103:
104: PROCEDURE check_parent_existance AS
105: CURSOR c_check_hz_exists IS
106: SELECT 'x' FROM hz_parties hp,igs_pe_hz_parties pe
107: WHERE hp.party_id = pe.party_id
108: AND pe.oss_org_unit_cd = new_references.preference_code;
109: cur_rec_hz_exists c_check_hz_exists%ROWTYPE;
110:

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

119: || Purpose : Checks for the existance of Parent records.
120: || Known limitations, enhancements or remarks :
121: || Change History :
122: || Who When What
123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in
124: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
125: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
126: || (reverse chronological order - newest change first)
127: */

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

120: || Known limitations, enhancements or remarks :
121: || Change History :
122: || Who When What
123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in
124: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
125: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
126: || (reverse chronological order - newest change first)
127: */
128: BEGIN

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

121: || Change History :
122: || Who When What
123: || sommukhe 12-AUG-2005 Bug#4377818,changed the c_check_hz_exists, included table igs_pe_hz_parties in
124: || FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
125: || using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
126: || (reverse chronological order - newest change first)
127: */
128: BEGIN
129: