DBA Data[Home] [Help]

APPS.IGS_PE_HZ_REL_PKG dependencies on HZ_PARTIES

Line 121: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c

117: SELECT a.rowid,
118: b.person_last_name surname,
119: b.person_first_name given_names,
120: b.person_pre_name_adjunct prefix
121: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c
122: WHERE a.relationship_id = c.relationship_id
123: AND c.subject_id = p_person_id
124: AND c.object_id = b.party_id
125: AND c.directional_flag = a.directional_flag

Line 134: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c

130: SELECT a.rowid,
131: b.person_last_name surname,
132: b.person_first_name given_names,
133: b.person_pre_name_adjunct prefix
134: FROM igs_pe_hz_rel a ,hz_parties b , hz_relationships c
135: WHERE a.relationship_id = c.relationship_id
136: AND c.subject_id = p_person_id
137: AND c.object_id = b.party_id
138: AND c.directional_flag = a.directional_flag