APPS.AR_GTA_CONC_PROG dependencies on AR_GTA_TRX_HEADERS_ALL

Line 282: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;

278: l_gt_header_count NUMBER;
279: l_gta_line_count NUMBER;
280: l_gt_line_count NUMBER;
281: l_line_count NUMBER;
282: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
283: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';

Line 283: l_source ar_gta_trx_headers_all.SOURCE%TYPE;

279: l_gta_line_count NUMBER;
280: l_gt_line_count NUMBER;
281: l_line_count NUMBER;
282: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
283: l_source ar_gta_trx_headers_all.SOURCE%TYPE;
284: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
285: l_output_msg VARCHAR2(2000);
286: l_no_data_flag VARCHAR2(1) := 'N';
287: l_report xmltype;

Line 305: ar_gta_trx_headers_all jgth

301: jgth.gta_trx_header_id
302: ,jgth.SOURCE
303: ,rct.customer_trx_id
304: FROM
305: ar_gta_trx_headers_all jgth
306: ,ra_customer_trx_all rct
307: WHERE jgth.org_id = l_org_id
308: AND jgth.status IN ('FAILED', 'COMPLETED', 'CANCELLED')
309: AND jgth.bill_to_customer_name LIKE nvl(p_customer_name,'%')