APPS.IBU_REQ_PKG dependencies on HZ_PARTIES

Line 185: from hz_parties

181: l_truncateCharNum number := 0;
182: l_responsibility_id NUMBER; --Wei Ma
183: cursor cur_contact_type(p_party_id number) is --UCONTACT
184: select party_type
185: from hz_parties
186: where party_id = p_party_id;
187:
188: l_sr_update_out_rec CS_ServiceRequest_PVT.sr_update_out_rec_type;
189: l_cs_auto_assignment VARCHAR2(1) := 'N';

Line 510: from hz_parties

506: IS
507:
508: cursor cur_contact_type(p_party_id number) is
509: select party_type
510: from hz_parties
511: where party_id = p_party_id;
512:
513: cursor get_ib_serial_tag_csr(p_instance_id number) is
514: select serial_number, external_reference