APPS.IEM_SERVICEREQUEST_PVT dependencies on HZ_PARTIES

Line 1005: FROM hz_parties a

1001:
1002: CURSOR caller_type
1003: IS
1004: SELECT party_type
1005: FROM hz_parties a
1006: WHERE a.party_id = p_party_id
1007: AND a.status = 'A'
1008: AND a.party_type IN ('ORGANIZATION','PERSON');
1009: l_coverage_template_id NUMBER;

Line 1073: from hz_parties

1069: ELSE
1070: IF (p_contact_id IS NOT NULL and p_employee_flag = 'N')
1071: THEN
1072: select party_type into l_contact_type
1073: from hz_parties
1074: where party_id = p_contact_id;
1075:
1076: l_index := 1;
1077: l_contacts(l_index).PARTY_ID := p_contact_id;