APPS.IEX_DUNNING_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 40: HZ_CUST_ACCT_SITES_ALL acct_site,

36: cursor get_data_crs(P_SITE_USE_ID number) is
37: select par_site.location_id
38: from
39: HZ_CUST_SITE_USES_ALL site_use,
40: HZ_CUST_ACCT_SITES_ALL acct_site,
41: hz_party_sites par_site
42: where
43: site_use.site_use_id = P_SITE_USE_ID and
44: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 164: from hz_cust_acct_sites_all where cust_acct_site_id =

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));
167: --End for bug 6500750 gnramasa 13-Nov-07
168:

Line 417: HZ_CUST_ACCT_SITES_ALL acct_site,

413: ) Display_Order
414: ,cont_point.CONTACT_POINT_ID
415: from
416: HZ_CUST_SITE_USES_ALL site_use,
417: HZ_CUST_ACCT_SITES_ALL acct_site,
418: hz_contact_points cont_point
419: where
420: site_use.site_use_id = P_SITE_USE_ID and
421: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 435: HZ_CUST_ACCT_SITES_ALL acct_site,

431: cursor get_data_crs3(P_SITE_USE_ID number) is
432: select par_site.location_id
433: from
434: HZ_CUST_SITE_USES_ALL site_use,
435: HZ_CUST_ACCT_SITES_ALL acct_site,
436: hz_party_sites par_site
437: where
438: site_use.site_use_id = P_SITE_USE_ID and
439: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 740: HZ_CUST_ACCT_SITES_ALL acct_site,

736: site_use.site_use_code,
737: par_site.location_id
738: from
739: hz_party_sites par_site,
740: HZ_CUST_ACCT_SITES_ALL acct_site,
741: HZ_CUST_SITE_USES_ALL site_use
742: where
743: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and
744: acct_site.status = 'A' and

Line 756: HZ_CUST_ACCT_SITES_ALL acct_site,

752: cursor get_data_crs3(P_CUST_ACCOUNT_ID number) is
753: select count(1)
754: from
755: hz_party_sites par_site,
756: HZ_CUST_ACCT_SITES_ALL acct_site,
757: HZ_CUST_SITE_USES_ALL site_use
758: where
759: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and
760: acct_site.status = 'A' and

Line 1125: HZ_CUST_ACCT_SITES_ALL acct_site,

1121: site_use.site_use_code,
1122: par_site.identifying_address_flag,
1123: site_use.primary_flag
1124: from HZ_CUST_SITE_USES_ALL site_use,
1125: HZ_CUST_ACCT_SITES_ALL acct_site,
1126: hz_party_sites par_site
1127: where par_site.party_id = P_PARTY_ID and
1128: par_site.status in ('A', 'I') and
1129: par_site.party_site_id = acct_site.party_site_id and

Line 1142: HZ_CUST_ACCT_SITES_ALL acct_site,

1138: P_IDENT_FLAG varchar2,
1139: P_PRIMARY_FLAG varchar2) is
1140: select count(1)
1141: from HZ_CUST_SITE_USES_ALL site_use,
1142: HZ_CUST_ACCT_SITES_ALL acct_site,
1143: hz_party_sites par_site
1144: where par_site.party_id = P_PARTY_ID and
1145: par_site.status in ('A', 'I') and
1146: par_site.party_site_id = acct_site.party_site_id and

Line 1294: hz_cust_acct_sites_all acc_site,

1290:
1291: cursor c_get_party_from_site(p_site_use_id number) is
1292: select cust.party_id
1293: from hz_cust_accounts cust,
1294: hz_cust_acct_sites_all acc_site,
1295: hz_cust_site_uses_all site_use
1296: where site_use.site_use_id = p_site_use_id and
1297: site_use.cust_acct_site_id = acc_site.cust_acct_site_id and
1298: acc_site.cust_account_id = cust.cust_account_id;

Line 1523: hz_cust_acct_sites_all acc_site,

1519:
1520: cursor c_get_site_info(p_site_use_id number) is
1521: select cust.party_id, cust.cust_account_id
1522: from hz_cust_accounts cust,
1523: hz_cust_acct_sites_all acc_site,
1524: hz_cust_site_uses_all site_use
1525: where site_use.site_use_id = p_site_use_id and
1526: site_use.cust_acct_site_id = acc_site.cust_acct_site_id and
1527: acc_site.cust_account_id = cust.cust_account_id;