APPS.ZX_AR_TAX_CLASSIFICATN_DEF_PKG dependencies on AR_VAT_TAX

Line 18: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;

14: c INTEGER;
15: rows INTEGER;
16: statement VARCHAR2(2000);
17: dummy VARCHAR2(25);
18: pg_tax_rate_passed ar_vat_tax.tax_rate%TYPE;
19: pg_adhoc_tax_code VARCHAR2(1);
20: curridx INTEGER := 1;
21: buf VARCHAR2(2160) := NULL;
22:

Line 930: FROM AR_VAT_TAX T

926: SELECT t.tax_code,
927: t.vat_tax_id,
928: amount_includes_tax_flag,
929: amount_includes_tax_override
930: FROM AR_VAT_TAX T
931: WHERE t.tax_code = c_tax_code
932: AND t.set_of_books_id = c_set_of_books_id
933: AND c_trx_date between t.start_date and
934: nvl(t.end_date, c_trx_date)

Line 1618: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |

1614: | HISTORY |
1615: | 27-NOV-95 Mahesh Sabapathy Created. |
1616: | 06-Jan-98 Mahesh Sabapathy Bugfix 604453: Exclude members of Tax Group|
1617: | 29-Feb-2000 Wei Feng, Bugfix 1205682: by changing the order of the FROM |
1618: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |
1619: *----------------------------------------------------------------------------*/
1620:
1621: FUNCTION get_customer_tax (
1622: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

Line 1931: -- l_tax_classification_code ar_vat_tax.tax_code%TYPE := null;

1927: p_party_flag IN VARCHAR2,
1928: p_party_location_id IN hz_locations.location_id%type) RETURN VARCHAR2 IS
1929:
1930: l_country hz_locations.country%TYPE := null;
1931: -- l_tax_classification_code ar_vat_tax.tax_code%TYPE := null;
1932:
1933: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1934:
1935: CURSOR sel_addr_country(