APPS.JMF_GTA_CONC_PROG dependencies on JMF_GTA_TRX_HEADERS_ALL

Line 263: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;

259: l_gt_header_count NUMBER;
260: l_gta_line_count NUMBER;
261: l_gt_line_count NUMBER;
262: l_line_count NUMBER;
263: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
264: l_source jmf_gta_trx_headers_all.SOURCE%TYPE;
265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';

Line 264: l_source jmf_gta_trx_headers_all.SOURCE%TYPE;

260: l_gta_line_count NUMBER;
261: l_gt_line_count NUMBER;
262: l_line_count NUMBER;
263: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
264: l_source jmf_gta_trx_headers_all.SOURCE%TYPE;
265: l_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
266: l_output_msg VARCHAR2(2000);
267: l_no_data_flag VARCHAR2(1) := 'N';
268: l_report xmltype;

Line 286: jmf_gta_trx_headers_all jgth

282: jgth.gta_trx_header_id
283: ,jgth.SOURCE
284: ,rct.customer_trx_id
285: FROM
286: jmf_gta_trx_headers_all jgth
287: ,ra_customer_trx_all rct
288: WHERE jgth.org_id = l_org_id
289: AND jgth.status IN ('FAILED', 'COMPLETED', 'CANCELLED')
290: AND jgth.bill_to_customer_name LIKE nvl(p_customer_name,'%')