APPS.IEX_DUNNING_PVT dependencies on HZ_PARTY_SITES

Line 43: hz_party_sites par_site

39: select par_site.location_id
40: from
41: HZ_CUST_SITE_USES_ALL site_use,
42: HZ_CUST_ACCT_SITES_ALL acct_site,
43: hz_party_sites par_site
44: where
45: site_use.site_use_id = P_SITE_USE_ID and
46: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and
47: 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 429: cont_point.owner_table_name = 'HZ_PARTY_SITES' and

425: where
426: site_use.site_use_id = P_SITE_USE_ID and
427: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and
428: cont_point.owner_table_id = acct_site.party_site_id and
429: cont_point.owner_table_name = 'HZ_PARTY_SITES' and
430: cont_point.contact_point_type = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'PHONE', 'FAX', 'PHONE') and
431: nvl(cont_point.phone_line_type, 'EMAIL') = decode(P_CONTACT_POINT_TYPE, 'EMAIL', 'EMAIL', 'PHONE', 'GEN', 'FAX', 'FAX') and
432: NVL(cont_point.do_not_use_flag, 'N') = 'N' and
433: (cont_point.status = 'A' OR cont_point.status <> 'I')

Line 442: hz_party_sites par_site

438: select par_site.location_id
439: from
440: HZ_CUST_SITE_USES_ALL site_use,
441: HZ_CUST_ACCT_SITES_ALL acct_site,
442: hz_party_sites par_site
443: where
444: site_use.site_use_id = P_SITE_USE_ID and
445: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and
446: par_site.party_site_id = acct_site.party_site_id;

Line 743: hz_party_sites par_site,

739: 'BILL_TO', decode(site_use.primary_flag, 'Y', 2, 3)) display_order,
740: site_use.site_use_code,
741: par_site.location_id
742: from
743: hz_party_sites par_site,
744: HZ_CUST_ACCT_SITES_ALL acct_site,
745: HZ_CUST_SITE_USES_ALL site_use
746: where
747: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and

Line 759: hz_party_sites par_site,

755: -- get count on not primary bill-to locations
756: cursor get_data_crs3(P_CUST_ACCOUNT_ID number) is
757: select count(1)
758: from
759: hz_party_sites par_site,
760: HZ_CUST_ACCT_SITES_ALL acct_site,
761: HZ_CUST_SITE_USES_ALL site_use
762: where
763: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and

Line 1128: hz_party_sites par_site

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

Line 1145: hz_party_sites par_site

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