APPS.ZX_AR_POPULATE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 3826: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;

3822: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3823: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3824: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3825: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3826: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3827: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3828: p_ret_record_level VARCHAR2(100);
3829: p_return_status VARCHAR2(100);
3830:

Line 3881: hz_cust_site_uses_all site_use ,

3877: -- site_use.tax_reference
3878: acct.party_id,
3879: acct_site.party_site_id
3880: FROM hz_cust_accounts acct,
3881: hz_cust_site_uses_all site_use ,
3882: hz_cust_acct_sites_all acct_site
3883: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
3884: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
3885: and site_use.site_use_id = c_site_use_id