eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_MISC_CASH_DIST dependencies on AR_VAT_TAX

Line 209: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax

205: l_ard_tax_rec ar_distributions%ROWTYPE;
206: l_ard_tax_rec_flag char(1);
207: l_ard_chk_first_rec char(1);
208: l_cr_rec ar_cash_receipts%ROWTYPE;
209: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax
210: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
211: ard_tbl_ctr number := 0; --counter to store AR Distribution record
212: -- in plsql Table
213: -- for 1543658

Line 210: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id

206: l_ard_tax_rec_flag char(1);
207: l_ard_chk_first_rec char(1);
208: l_cr_rec ar_cash_receipts%ROWTYPE;
209: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax
210: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
211: ard_tbl_ctr number := 0; --counter to store AR Distribution record
212: -- in plsql Table
213: -- for 1543658
214: -- this cursor stores all AR Distributions lines except the one

Line 295: ar_vat_tax avt,

291: l_vat_tax_id , --tax_code_id
292: l_precision ,
293: l_min_unit
294: from ar_cash_receipts cr,
295: ar_vat_tax avt,
296: fnd_currencies fc
297: where cr.cash_receipt_id = p_cash_receipt_id
298: and cr.currency_code = fc.currency_code
299: and cr.vat_tax_id = avt.vat_tax_id(+);

Line 751: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax

747: l_ard_tax_rec ar_distributions%ROWTYPE;
748: l_ard_tax_rec_flag char(1);
749: l_ard_chk_first_rec char(1);
750: l_cr_rec ar_cash_receipts%ROWTYPE;
751: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax
752: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
753: ard_tbl_ctr number := 0; --counter to store AR Distribution record
754: -- in plsql Table
755: -- for 1543658

Line 752: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id

748: l_ard_tax_rec_flag char(1);
749: l_ard_chk_first_rec char(1);
750: l_cr_rec ar_cash_receipts%ROWTYPE;
751: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax
752: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
753: ard_tbl_ctr number := 0; --counter to store AR Distribution record
754: -- in plsql Table
755: -- for 1543658
756: -- this cursor stores all AR Distributions lines except the one

Line 841: ar_vat_tax avt,

837: l_vat_tax_id , --tax_code_id
838: l_precision ,
839: l_min_unit
840: from ar_cash_receipts cr,
841: ar_vat_tax avt,
842: fnd_currencies fc
843: where cr.cash_receipt_id = p_cash_receipt_id
844: and cr.currency_code = fc.currency_code
845: and cr.vat_tax_id = avt.vat_tax_id(+);