APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2226: hz_cust_acct_sites_all acct_site

2222: site_use.location,
2223: site_use.tax_reference
2224: FROM hz_cust_accounts acct,
2225: hz_cust_site_uses_all site_use ,
2226: hz_cust_acct_sites_all acct_site
2227: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
2228: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
2229: and acct_site.PARTY_SITE_ID = c_party_site_id
2230: and ACCT.PARTY_ID = c_party_id

Line 2244: hz_cust_acct_sites_all acct_site

2240:
2241: CURSOR migrated_party_site_cur ( c_cust_acct_site_id ZX_REP_TRX_DETAIL_T.BILLING_TP_ADDRESS_ID%TYPE) IS
2242: SELECT PARTY_SITE.party_site_id
2243: FROM HZ_PARTY_SITES PARTY_SITE,
2244: hz_cust_acct_sites_all acct_site
2245: WHERE acct_site.cust_acct_site_id = c_cust_acct_site_id
2246: AND party_site.party_site_id = acct_site. party_site_id;
2247:
2248: BEGIN

Line 2697: hz_cust_acct_sites_all acct_site

2693: site_use.location,
2694: site_use.tax_reference
2695: FROM hz_cust_accounts acct,
2696: hz_cust_site_uses_all site_use ,
2697: hz_cust_acct_sites_all acct_site
2698: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
2699: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
2700: and acct_site.PARTY_SITE_ID = c_party_site_id
2701: and ACCT.PARTY_ID = c_party_id

Line 2711: FROM hz_cust_acct_sites_all acct_site,

2707: WHERE acct.cust_account_id = c_cust_acct_id;
2708:
2709: CURSOR party_site_id_cur ( c_cust_site_use_id ZX_REP_TRX_DETAIL_T.BILLING_TP_SITE_ID%TYPE) IS
2710: SELECT acct_site.party_site_id
2711: FROM hz_cust_acct_sites_all acct_site,
2712: hz_cust_site_uses_all site_use
2713: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2714: AND site_use.site_use_id = c_cust_site_use_id;
2715: