APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on AR_TRX_LINES_GT

Line 671: ar_trx_lines_gt l,

667: CURSOR c_cnt_tax_codes_ai(x_customer_trx_id NUMBER) IS
668: SELECT
669: COUNT(DISTINCT tax.tax_rate_code)
670: FROM
671: ar_trx_lines_gt l,
672: --
673: -- Bug 4756219
674: -- Changing reference to ar vat tax to zx_mco_rates
675: zx_mco_rates tax

Line 826: from ar_trx_lines_gt

822: UPDATE ar_trx_header_gt
823: SET global_attribute1 = l_gui_type
824: WHERE trx_header_id =
825: (select trx_header_id
826: from ar_trx_lines_gt
827: where trx_line_id = l_trx_line_id);
828: **
829: **
830: */

Line 859: ar_trx_lines_gt lines

855: CURSOR interface_line IS
856: SELECT header.trx_header_id,
857: lines.trx_line_id
858: FROM ar_trx_header_gt header,
859: ar_trx_lines_gt lines
860: WHERE lines.customer_trx_id = p_customer_trx_id
861: AND lines.trx_header_id = header.trx_header_id;
862:
863: cannot_insert_error EXCEPTION;

Line 998: FROM ar_trx_lines_gt l,

994: AND a.interim_tax_ccid is NULL;
995: ELSIF p_created_from = 'RAXTRX' THEN
996: SELECT count(l.customer_trx_line_id)
997: INTO n
998: FROM ar_trx_lines_gt l,
999: -- Bug 4756219
1000: -- Changing reference to ar vat tax to zx_mco_rates
1001: zx_mco_rates v,
1002: zx_accounts a