APPS.IGS_PE_HZ_REL_PKG dependencies on HZ_RELATIONSHIPS

Line 109: FROM igs_pe_hz_rel a , hz_relationships d

105: -- cursor to get the surname, prefix, given_names of member
106: --
107: CURSOR check_update IS
108: SELECT d.subject_id
109: FROM igs_pe_hz_rel a , hz_relationships d
110: WHERE a.rowid = p_rowid
111: AND (NVL(a.primary,'N') = 'Y' OR NVL(a.secondary,'N') = 'Y')
112: AND d.relationship_id = a.relationship_id
113: AND a.directional_flag = d.directional_flag;

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

Line 155: l_member_id1 hz_relationships.object_id%TYPE;

151: AND security_group_id = p_security_group_id
152: AND lookup_code = p_prefix
153: AND enabled_flag = 'Y';
154:
155: l_member_id1 hz_relationships.object_id%TYPE;
156: l_member_id2 hz_relationships.object_id%TYPE;
157: rec_prime_member_detail c_member_detail1%ROWTYPE;
158: rec_sec_member_detail c_member_detail2%ROWTYPE;
159: lv_joint_salutation VARCHAR2(750);

Line 156: l_member_id2 hz_relationships.object_id%TYPE;

152: AND lookup_code = p_prefix
153: AND enabled_flag = 'Y';
154:
155: l_member_id1 hz_relationships.object_id%TYPE;
156: l_member_id2 hz_relationships.object_id%TYPE;
157: rec_prime_member_detail c_member_detail1%ROWTYPE;
158: rec_sec_member_detail c_member_detail2%ROWTYPE;
159: lv_joint_salutation VARCHAR2(750);
160: lv_update VARCHAR2(1);

Line 346: SELECT 'Y' FROM HZ_RELATIONSHIPS

342: || Who When What
343: || (reverse chronological order - newest change first)
344: */
345: CURSOR rel_pk IS
346: SELECT 'Y' FROM HZ_RELATIONSHIPS
347: WHERE relationship_id = new_references.relationship_id AND
348: directional_flag = new_references.directional_flag;
349:
350: l_var VARCHAR2(1);