APPS.ZX_AR_POPULATE_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 3403: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;

3399: p_tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE;
3400: p_jurisdiction_code ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE;
3401: p_account_id ZX_REGISTRATIONS.ACCOUNT_ID%TYPE;
3402: p_account_site_id ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE;
3403: p_site_use_id HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE;
3404: p_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
3405: p_ret_record_level VARCHAR2(100);
3406: p_return_status VARCHAR2(100);
3407:

Line 3495: hz_cust_site_uses_all site_use ,

3491: -- site_use.tax_reference
3492: acct.party_id,
3493: acct_site.party_site_id
3494: FROM hz_cust_accounts acct,
3495: hz_cust_site_uses_all site_use ,
3496: hz_cust_acct_sites_all acct_site
3497: WHERE acct.CUST_ACCOUNT_ID = acct_site.CUST_ACCOUNT_ID
3498: and acct_site.CUST_ACCT_SITE_ID = site_use.CUST_ACCT_SITE_ID
3499: and site_use.site_use_id = c_site_use_id