APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on HZ_PARTY_SITE_USES
Line 17: FROM hz_party_site_uses
13: )
14: IS
15: CURSOR l_cur IS
16: SELECT party_site_use_id 17: FROM hz_party_site_uses 18: WHERE party_site_id = p_party_site_id
19: AND site_use_type = p_address_type
20: AND status = 'A';
21:
Line 115: FROM hz_party_site_uses
111: )
112: IS
113: CURSOR l_cur IS
114: SELECT party_site_use_id, object_version_number 115: FROM hz_party_site_uses 116: WHERE party_site_id = p_party_site_id
117: AND site_use_type = p_address_type
118: AND status = 'A';
119: