APPS.IBU_REQ_PKG dependencies on HZ_PARTIES

Line 173: from hz_parties

169: l_truncateCharNum number := 0;
170: l_responsibility_id NUMBER; --Wei Ma
171: cursor cur_contact_type(p_party_id number) is --UCONTACT
172: select party_type
173: from hz_parties
174: where party_id = p_party_id;
175:
176: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
177: l_cs_auto_assignment VARCHAR2(1) := 'N';

Line 486: from hz_parties

482: IS
483:
484: cursor cur_contact_type(p_party_id number) is
485: select party_type
486: from hz_parties
487: where party_id = p_party_id;
488:
489: cursor get_ib_serial_tag_csr(p_instance_id number) is
490: select serial_number, external_reference