DBA Data[Home] [Help]

APPS.PN_EXP_TO_AR dependencies on AR_VAT_TAX

Line 61: FROM ar_vat_tax

57: WHERE batch_source_id = 24;
58:
59: CURSOR get_tax_code (p_tax_code_id number) is
60: SELECT tax_code
61: FROM ar_vat_tax
62: WHERE vat_tax_id = p_tax_code_id;
63:
64: CURSOR acnt_cls_cur(p_term_id NUMBER) IS
65: SELECT account_class

Line 596: l_tax_code AR_VAT_TAX.tax_code%TYPE;

592: l_min_acct_unit NUMBER;
593: t_count NUMBER := 0;
594: e_count NUMBER := 0;
595: s_count NUMBER := 0;
596: l_tax_code AR_VAT_TAX.tax_code%TYPE;
597: l_tax_classification_code pn_payment_terms.tax_classification_code%TYPE;
598: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
599: l_rev_flag VARCHAR2(1);
600: l_rec_flag VARCHAR2(1);

Line 1937: l_tax_code AR_VAT_TAX.tax_code%TYPE;

1933: l_min_acct_unit NUMBER;
1934: t_count NUMBER := 0;
1935: e_count NUMBER := 0;
1936: s_count NUMBER := 0;
1937: l_tax_code AR_VAT_TAX.tax_code%TYPE;
1938: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
1939: l_rev_flag VARCHAR2(1);
1940: l_rec_flag VARCHAR2(1);
1941: l_ast_flag VARCHAR2(1);