APPS.IEM_SERVICEREQUEST_PVT dependencies on HZ_PARTIES

Line 1011: FROM hz_parties a

1007:
1008: CURSOR caller_type
1009: IS
1010: SELECT party_type
1011: FROM hz_parties a
1012: WHERE a.party_id = p_party_id
1013: AND a.status = 'A'
1014: AND a.party_type IN ('ORGANIZATION','PERSON');
1015: l_coverage_template_id NUMBER;

Line 1090: from hz_parties

1086: ELSE
1087: IF (p_contact_id IS NOT NULL and p_employee_flag = 'N')
1088: THEN
1089: select party_type into l_contact_type
1090: from hz_parties
1091: where party_id = p_contact_id;
1092:
1093: l_index := 1;
1094: l_contacts(l_index).PARTY_ID := p_contact_id;