DBA Data[Home] [Help]

APPS.AR_RAXSKI_XMLP_PKG dependencies on HZ_CUST_ACCT_SITES

Line 171: from hz_cust_acct_sites acct_site,

167:
168:
169: select count(*)
170: into v_addresses_t
171: from hz_cust_acct_sites acct_site,
172: hz_party_sites party_site,
173: hz_loc_assignments loc_assign
174: where acct_site.party_site_id = party_site.party_site_id
175: and party_site.location_id = loc_assign.location_id

Line 183: from hz_cust_acct_sites acct_site,

179:
180:
181: select count(*)
182: into prior_v_addresses_t
183: from hz_cust_acct_sites acct_site,
184: hz_party_sites party_site,
185: hz_loc_assignments loc_assign
186: where acct_site.party_site_id = party_site.party_site_id
187: and party_site.location_id = loc_assign.location_id

Line 195: from hz_cust_acct_sites acct_site,

191:
192:
193: select count(*)
194: into address_total_number_t
195: from hz_cust_acct_sites acct_site,
196: hz_party_sites party_site,
197: hz_loc_assignments loc_assign
198: where acct_site.party_site_id = party_site.party_site_id
199: and party_site.location_id = loc_assign.location_id