DBA Data[Home] [Help]

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: