APPS.AST_ROUTING_PUB dependencies on HZ_PARTIES

Line 18: from hz_parties

14: and customer_id = p_cust_id;
15:
16: cursor get_partytype (p_cust_id NUMBER) is
17: select party_type
18: from hz_parties
19: where party_id = p_cust_id;
20:
21: cursor get_subject_object (p_rel_party_id NUMBER) is
22: select subject_id, object_id

Line 118: and owner_table_name = 'HZ_PARTIES'

114: cursor getPartyIDfromANI (p_ANI VARCHAR2) is
115: select owner_table_id
116: from hz_contact_points
117: where transposed_phone_number like p_ANI
118: and owner_table_name = 'HZ_PARTIES'
119: and status = 'A';
120:
121: begin
122: l_filtered_ANI := translate(p_object_value,

Line 157: from hz_parties

153: l_object_value NUMBER;
154:
155: cursor getPartyIDfromPartyID (p_PartyID NUMBER) is
156: select party_id
157: from hz_parties
158: where party_id = p_PartyID;
159:
160: begin
161: if p_object_value is null or p_object_value = '' then

Line 193: from hz_parties

189: l_more_partyID NUMBER;
190:
191: cursor getPartyIDfromPartyNum (p_PartyNum VARCHAR2) is
192: select party_id
193: from hz_parties
194: where party_number = p_PartyNum;
195:
196: begin
197: if p_object_value is null or p_object_value = '' then

Line 485: and owner_party_source_table = 'HZ_PARTIES';

481: cursor getPartyIDfromServiceKey (p_ServiceKey VARCHAR2) is
482: select owner_party_id
483: from csi_item_instances
484: where instance_number = p_ServiceKey
485: and owner_party_source_table = 'HZ_PARTIES';
486:
487: begin
488: if p_object_value is null or p_object_value = '' then
489: return G_NO_PARTY;

Line 558: from hz_parties

554: p_party_id OUT NOCOPY NUMBER) is
555:
556: cursor getPartyName (p_PartyID NUMBER) is
557: select party_name
558: from hz_parties
559: where party_id = p_PartyID;
560:
561: begin
562: p_party_id := G_NO_PARTY;