APPS.IEX_DUNNING_PVT dependencies on AST_LOCATIONS_V

Line 162: from ast_locations_v where party_site_id =

158:
159: --start for bug 6500750 gnramasa 13-Nov-07
160: cursor get_site_loc(P_CONTACT_ID number) is
161: select location_id
162: from ast_locations_v where party_site_id =
163: (select party_site_id
164: from hz_cust_acct_sites_all where cust_acct_site_id =
165: (select address_id
166: from ar_contacts_v where contact_party_id = P_CONTACT_ID));

Line 172: from ast_locations_v

168:
169: -- get organization location_id
170: cursor get_old_loc_crs1(P_ORG_PARTY_ID number) is
171: select location_id
172: from ast_locations_v
173: where party_id = P_ORG_PARTY_ID and
174: primary_flag = 'Y';
175:
176: BEGIN

Line 772: from ast_locations_v

768: -- Start for bug 6500750 gnramasa 13-Nov-07
769:
770: cursor get_old_loc_crs1(P_ORG_PARTY_ID number) is
771: select location_id
772: from ast_locations_v
773: where party_id = P_ORG_PARTY_ID and
774: primary_flag = 'Y';
775:
776: -- End for bug 6500750 gnramasa 13-Nov-07