APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1517: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;

1513: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1514: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1515: RETURN VARCHAR2 IS
1516:
1517: l_cust_acct_site_id HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE;
1518: l_party_tax_profile_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1519: l_zx_registration_rec ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC;
1520: l_tax_classification_code HZ_CUST_SITE_USES.tax_code%TYPE;
1521: l_ret_record_level VARCHAR2(30);

Line 1526: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;

1522: l_return_status VARCHAR2(80);
1523: l_error_buffer VARCHAR2(100);
1524:
1525: l_parent_ptp_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1526: l_cust_account_id HZ_CUST_ACCT_SITES.CUST_ACCOUNT_ID%TYPE;
1527:
1528: CURSOR get_site_tax_info
1529: (c_site_use_id hz_cust_site_uses.site_use_id%TYPE,
1530: c_org_id NUMBER,

Line 1654: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,

1650: (c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1651: IS
1652: SELECT CUST_ACCT.cust_account_id
1653: FROM HZ_CUST_ACCOUNTS CUST_ACCT,
1654: HZ_CUST_ACCT_SITES CUST_ACCT_SITES,
1655: HZ_CUST_SITE_USES CUST_SITE_USES
1656: WHERE CUST_ACCT.cust_account_id = CUST_ACCT_SITES.cust_account_id
1657: AND CUST_ACCT_SITES.cust_acct_site_id = CUST_SITE_USES.cust_acct_site_id
1658: AND CUST_SITE_USES.site_use_id = c_site_use_id;

Line 1953: FROM HZ_CUST_ACCT_SITES acct_site,

1949: CURSOR sel_addr_country(
1950: c_site_use_id HZ_CUST_SITE_USES.site_use_id%TYPE)
1951: IS
1952: SELECT loc.country
1953: FROM HZ_CUST_ACCT_SITES acct_site,
1954: HZ_PARTY_SITES party_site,
1955: HZ_LOCATIONS loc,
1956: HZ_CUST_SITE_USES site_uses
1957: WHERE site_uses.site_use_id = c_site_use_id