APPS.IEX_DUNNING_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 39: HZ_CUST_SITE_USES_ALL site_use,

35: +-----------------------------------------------------------------------*/
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

Line 364: HZ_CUST_SITE_USES_ALL site_use,

360: role_resp.responsibility_type,
361: party.party_id,
362: sub_party.party_id
363: from
364: HZ_CUST_SITE_USES_ALL site_use,
365: HZ_CUST_ACCOUNT_ROLES acct_role,
366: HZ_ROLE_RESPONSIBILITY role_resp,
367: HZ_RELATIONSHIPS rel,
368: hz_parties party,

Line 416: HZ_CUST_SITE_USES_ALL site_use,

412: null, decode(cont_point.primary_flag, 'Y', 10, decode(cont_point.primary_by_purpose, 'Y', 11, 12))
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

Line 434: HZ_CUST_SITE_USES_ALL site_use,

430: -- get LOCATION_ID for specified site_use_id
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

Line 741: HZ_CUST_SITE_USES_ALL site_use

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
745: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 757: HZ_CUST_SITE_USES_ALL site_use

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
761: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 1124: from HZ_CUST_SITE_USES_ALL site_use,

1120: acct_site.cust_account_id,
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

Line 1141: from HZ_CUST_SITE_USES_ALL site_use,

1137: P_SITE_USE_CODE varchar2,
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

Line 1295: hz_cust_site_uses_all site_use

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;
1299:

Line 1524: hz_cust_site_uses_all site_use

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;
1528: