eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on HZ_CUST_ACCOUNTS

Line 49: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

45: RETURN VARCHAR2;
46:
47: FUNCTION get_customer_tax(
48: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
49: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
50: p_trx_date IN ra_customer_trx.trx_date%TYPE )
51: RETURN VARCHAR2;
52:
53: FUNCTION get_item_tax(

Line 1623: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

1619: *----------------------------------------------------------------------------*/
1620:
1621: FUNCTION get_customer_tax (
1622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1623: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1624: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1625: RETURN VARCHAR2 IS
1626:
1627: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

Line 1627: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

1623: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1624: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1625: RETURN VARCHAR2 IS
1626:
1627: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1628: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
1629:
1630: l_ret_record_level VARCHAR2(30);
1631: l_return_status VARCHAR2(80);

Line 1628: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;

1624: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1625: RETURN VARCHAR2 IS
1626:
1627: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1628: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
1629:
1630: l_ret_record_level VARCHAR2(30);
1631: l_return_status VARCHAR2(80);
1632: l_error_buffer VARCHAR2(100);

Line 1639: FROM HZ_CUST_ACCOUNTS CUST_ACCT,

1635: CURSOR get_customer_id
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

Line 1648: (c_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

1644: AND CUST_SITE_USES.site_use_id = c_site_use_id;
1645:
1646:
1647: CURSOR sel_customer_tax
1648: (c_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1649: c_org_id NUMBER,
1650: c_trx_date DATE)
1651: IS
1652: SELECT c.tax_code

Line 1653: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l

1649: c_org_id NUMBER,
1650: c_trx_date DATE)
1651: IS
1652: SELECT c.tax_code
1653: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l
1654: WHERE c.cust_account_id = c_customer_id
1655: AND c.org_id = c_org_id
1656: AND l.lookup_code = c.tax_code
1657: AND l.org_id IN (c_org_id, -99)