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 1637: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,

1633: *----------------------------------------------------------------------------*/
1634:
1635: FUNCTION get_customer_tax (
1636: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,
1637: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1638: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1639: RETURN VARCHAR2 IS
1640:
1641: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

Line 1641: l_customer_id hz_cust_accounts.cust_account_id%TYPE;

1637: p_customer_id IN hz_cust_accounts.cust_account_id%TYPE,
1638: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1639: RETURN VARCHAR2 IS
1640:
1641: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1642: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
1643:
1644: l_ret_record_level VARCHAR2(30);
1645: l_return_status VARCHAR2(80);

Line 1642: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;

1638: p_trx_date IN ra_customer_trx.trx_date%TYPE)
1639: RETURN VARCHAR2 IS
1640:
1641: l_customer_id hz_cust_accounts.cust_account_id%TYPE;
1642: l_tax_classification_code HZ_CUST_ACCOUNTS.tax_code%TYPE;
1643:
1644: l_ret_record_level VARCHAR2(30);
1645: l_return_status VARCHAR2(80);
1646: l_error_buffer VARCHAR2(100);

Line 1653: FROM HZ_CUST_ACCOUNTS CUST_ACCT,

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

Line 1662: (c_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

1658: AND CUST_SITE_USES.site_use_id = c_site_use_id;
1659:
1660:
1661: CURSOR sel_customer_tax
1662: (c_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1663: c_org_id NUMBER,
1664: c_trx_date DATE)
1665: IS
1666: SELECT c.tax_code

Line 1667: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l

1663: c_org_id NUMBER,
1664: c_trx_date DATE)
1665: IS
1666: SELECT c.tax_code
1667: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l
1668: WHERE c.cust_account_id = c_customer_id
1669: AND c.org_id = c_org_id
1670: AND l.lookup_code = c.tax_code
1671: AND l.org_id IN (c_org_id, -99)