APPS.IEX_CASE_CONTACTS_PVT dependencies on HZ_PARTY_SITES

Line 47: FROM HZ_PARTY_SITES

43: Cursor c2 is SELECT IEX_CASE_CONTACTS_S.nextval from dual;
44:
45: CURSOR C_GET_ADDRESS(P_PARTY_ID NUMBER) IS
46: SELECT PARTY_SITE_ID
47: FROM HZ_PARTY_SITES
48: WHERE PARTY_ID = P_PARTY_ID
49: AND IDENTIFYING_ADDRESS_FLAG = 'Y';
50:
51: cursor c_get_phone(x_owner_table_id number) is