APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_CMN_DOCUMENT_TAXES_S

Line 4533: --jai_cmn_document_taxes.source_doc_line_id

4529: ( ln_invoice_id
4530: , ap_invoice_lines_rec.line_number
4531: );
4532: --update the tax line number for the filed of
4533: --jai_cmn_document_taxes.source_doc_line_id
4534: --and split each PR taxes into to two lines
4535: FOR jai_default_doc_taxes_rec IN
4536: jai_default_doc_taxes_cur
4537: ( pn_invoice_id =>ln_invoice_id

Line 4740: jai_cmn_document_taxes_s.nextval

4736: ------------------------------------------------------
4737: --Eric Ma added for two records shown in Form,end
4738:
4739: SELECT
4740: jai_cmn_document_taxes_s.nextval
4741: INTO
4742: ln_doc_tax_id
4743: FROM DUAL;
4744:

Line 5099: -- Line number got from max jai_cmn_document_taxes.source_doc_line_id

5095:
5096: --insert into eric_log values (7.91,'jai_doc_taxes_rec.inc_tax_flag =''Y'' AND recoverable with project case ',sysdate);
5097:
5098: -- Insert negative line with project info
5099: -- Line number got from max jai_cmn_document_taxes.source_doc_line_id
5100: -- or max ap_invoice_lines_all.line_number
5101: ln_max_inv_line_num := Get_Max_Invoice_Line_Number(ln_invoice_id);
5102:
5103: -- deleted by eric for fixing the bug of bug#6784111 on 29-JAN,2008,begin