APPS.IEX_DUNNING_PVT dependencies on HZ_PARTY_SITES

Line 41: hz_party_sites par_site

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
45: par_site.party_site_id = acct_site.party_site_id;

Line 155: from hz_party_sites

151:
152: -- get relationship location_id
153: cursor get_old_loc_crs(P_REL_PARTY_ID number) is
154: select location_id
155: from hz_party_sites
156: where party_id = P_REL_PARTY_ID and
157: status in ('A', 'I');
158:
159: --start for bug 6500750 gnramasa 13-Nov-07

Line 423: cont_point.owner_table_name = 'HZ_PARTY_SITES' and

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
422: cont_point.owner_table_id = acct_site.party_site_id and
423: cont_point.owner_table_name = 'HZ_PARTY_SITES' and
424: cont_point.contact_point_type = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and
425: nvl(cont_point.phone_line_type, 'EMAIL') = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'GEN', 'FAX', 'FAX') and
426: NVL(cont_point.do_not_use_flag, 'N') = 'N' and
427: (cont_point.status = 'A' OR cont_point.status <> 'I')

Line 436: hz_party_sites par_site

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
440: par_site.party_site_id = acct_site.party_site_id;

Line 739: hz_party_sites par_site,

735: 'BILL_TO', decode(site_use.primary_flag, 'Y', 2, 3)) display_order,
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

Line 755: hz_party_sites par_site,

751: -- get count on not primary bill-to locations
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

Line 1126: hz_party_sites par_site

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
1130: acct_site.status = 'A' and

Line 1143: hz_party_sites par_site

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
1147: acct_site.status = 'A' and