APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1503: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;

1499: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1500: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1501: RETURN VARCHAR2 IS
1502:
1503: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;
1504: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1505: l_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1506: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;
1507: l_ret_record_level VARCHAR2(30);

Line 1512: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;

1508: l_return_status VARCHAR2(80);
1509: l_error_buffer VARCHAR2(100);
1510:
1511: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1512: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;
1513:
1514: CURSOR get_site_tax_info
1515: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,
1516: c_org_id NUMBER,

Line 1640: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,

1636: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1637: IS
1638: SELECT CUST_ACCT.cust_account_id
1639: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1640: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,
1641: HZ_CUST_SITE_USES CUST_SITE_USES
1642: WHERE CUST_ACCT.cust_account_id = CUST_ACCT_SITES.cust_account_id
1643: AND CUST_ACCT_SITES.cust_acct_site_id = CUST_SITE_USES.cust_acct_site_id
1644: AND CUST_SITE_USES.site_use_id = c_site_use_id;

Line 1939: FROM HZ_CUST_ACCT_SITES acct_site,

1935: CURSOR sel_addr_country(
1936: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1937: IS
1938: SELECT loc.country
1939: FROM HZ_CUST_ACCT_SITES acct_site,
1940: HZ_PARTY_SITES party_site,
1941: HZ_LOCATIONS loc,
1942: HZ_CUST_SITE_USES site_uses
1943: WHERE site_uses.site_use_id = c_site_use_id