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 1632: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |

1628: | HISTORY |
1629: | 27-NOV-95 Mahesh Sabapathy Created. |
1630: | 06-Jan-98 Mahesh Sabapathy Bugfix 604453: Exclude members of Tax Group|
1631: | 29-Feb-2000 Wei Feng, Bugfix 1205682: by changing the order of the FROM |
1632: | clause to have RA_CUSTORMER preceding AR_VAT_TAX. |
1633: *----------------------------------------------------------------------------*/
1634:
1635: FUNCTION get_customer_tax (
1636: p_site_use_id IN hz_cust_site_uses.site_use_id%TYPE,

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

1941: p_party_flag IN VARCHAR2,
1942: p_party_location_id IN hz_locations.location_id%type) RETURN VARCHAR2 IS
1943:
1944: l_country hz_locations.country%TYPE := null;
1945: -- l_tax_classification_code ar_vat_tax.tax_code%TYPE := null;
1946:
1947: l_tax_classification_code zx_lines_det_factors.output_tax_classification_code%TYPE;
1948:
1949: CURSOR sel_addr_country(