DBA Data[Home] [Help]

APPS.ZX_AR_ACTG_POPULATE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 2225: hz_cust_site_uses_all site_use ,

2221: acct_site.global_attribute9,
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

Line 2696: hz_cust_site_uses_all site_use ,

2692: acct_site.global_attribute9,
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

Line 2712: hz_cust_site_uses_all site_use

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:
2716: