APPS.WSH_CONTACT_PERSON_PKG dependencies on HZ_PARTIES

Line 162: l_rel_rec_type.subject_table_name := 'HZ_PARTIES';

158: -- Put Information into party_rel_rec.
159: l_rel_rec_type.relationship_type := 'EMPLOYMENT';
160: l_rel_rec_type.relationship_code := 'EMPLOYEE_OF';
161: l_rel_rec_type.subject_id := l_person_party_id;
162: l_rel_rec_type.subject_table_name := 'HZ_PARTIES';
163: l_rel_rec_type.subject_type := 'PERSON';
164: l_rel_rec_type.object_id := p_carrier_party_id;
165: l_rel_rec_type.object_table_name := 'HZ_PARTIES';
166: l_rel_rec_type.object_type := 'ORGANIZATION';

Line 165: l_rel_rec_type.object_table_name := 'HZ_PARTIES';

161: l_rel_rec_type.subject_id := l_person_party_id;
162: l_rel_rec_type.subject_table_name := 'HZ_PARTIES';
163: l_rel_rec_type.subject_type := 'PERSON';
164: l_rel_rec_type.object_id := p_carrier_party_id;
165: l_rel_rec_type.object_table_name := 'HZ_PARTIES';
166: l_rel_rec_type.object_type := 'ORGANIZATION';
167: l_rel_rec_type.start_date := sysdate;
168: l_rel_rec_type.created_by_module := 'ORACLE_SHIPPING';
169: l_rel_rec_type.party_rec.status := P_STATUS;

Line 258: from hz_parties

254: l_call_procedure varchar2(100);
255:
256: CURSOR Get_Object_Version_Number(p_person_party_id NUMBER) IS
257: select object_version_number
258: from hz_parties
259: where party_id = p_person_party_id;
260:
261: --
262: l_debug_on BOOLEAN;