APPS.AR_GTA_CONSOLIDATE_PROC dependencies on AR_GTA_TRX_LINES_ALL

Line 465: l_tax_rate ar_gta_trx_lines_all.tax_rate%TYPE;--Yao add for bug 9655856

461: l_consolidation_gl_period Varchar2(20);
462: l_consolidation_gl_date DATE;
463: l_csldted_inv_status_flag VARCHAR2(1);--yao add for bug#8882568
464: l_gta_consol_temp_seq NUMBER;
465: l_tax_rate ar_gta_trx_lines_all.tax_rate%TYPE;--Yao add for bug 9655856
466:
467: --added by jixun for ER#16613351 begin
468: /*-------------------------------------------------------
469: Store the Transaction Type of Consolidated GTA Invoices.

Line 491: FROM ar_gta_trx_headers_all jgth, ar_gta_trx_lines_all jgtl

487: jgth.bank_account_name,
488: jgth.bank_account_number,
489: jgth.invoice_type,
490: jgtl.tax_rate --Yao add for bug9655856
491: FROM ar_gta_trx_headers_all jgth, ar_gta_trx_lines_all jgtl
492: WHERE jgth.consolidation_id = p_consolidation_id
493: --Yao add for bug 9655856
494: AND jgth.gta_trx_header_id = jgtl.gta_trx_header_id
495: AND jgth.org_id = jgtl.org_id

Line 544: FROM ar_gta_trx_lines_all jgtl

540: AND jgth.invoice_type = p_invoice_type
541: --Yao add for bug 9655856
542:
543: AND jgth.gta_trx_header_id = (SELECT jgtl.gta_trx_header_id
544: FROM ar_gta_trx_lines_all jgtl
545: WHERE jgtl.tax_rate=p_tax_rate
546: AND jgth.gta_trx_header_id = jgtl.gta_trx_header_id
547: AND jgth.org_id = jgtl.org_id
548: GROUP BY jgtl.gta_trx_header_id)

Line 1367: SELECT ar_gta_trx_lines_all_s.NEXTVAL

1363:
1364: l_csldtion_inv_lines_index:=l_csldtion_inv.trx_lines.FIRST;
1365: WHILE l_csldtion_inv_lines_index IS NOT NULL
1366: LOOP
1367: SELECT ar_gta_trx_lines_all_s.NEXTVAL
1368: INTO l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).gta_trx_line_id
1369: FROM dual;
1370: l_csldtion_inv.trx_lines(l_csldtion_inv_lines_index).gta_trx_header_id
1371: :=l_csldtion_inv.trx_header.gta_trx_header_id;