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 592: l_tax_code AR_VAT_TAX.tax_code%TYPE;

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

Line 1891: l_tax_code AR_VAT_TAX.tax_code%TYPE;

1887: l_min_acct_unit NUMBER;
1888: t_count NUMBER := 0;
1889: e_count NUMBER := 0;
1890: s_count NUMBER := 0;
1891: l_tax_code AR_VAT_TAX.tax_code%TYPE;
1892: l_rev_acc_alloc_rule RA_BATCH_SOURCES.rev_acc_allocation_rule%TYPE;
1893: l_rev_flag VARCHAR2(1);
1894: l_rec_flag VARCHAR2(1);
1895: l_ast_flag VARCHAR2(1);