APPS.AR_TRX_BULK_PROCESS_DIST dependencies on AR_TRX_ERRORS_GT

Line 126: ar_trx_errors_gt )

122: ar_trx_lines_gt l
123: WHERE d.trx_line_id = l.trx_line_id(+)
124: and d.trx_header_id = h.trx_header_id
125: AND d.trx_header_ID NOT IN ( SELECT trx_header_id from
126: ar_trx_errors_gt )
127: AND d.trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
128: AND d.process_flag = 'N';
129:
130: UPDATE ar_trx_dist_gt

Line 136: FROM ar_trx_errors_gt );

132: WHERE trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
133: AND process_flag = 'N'
134: AND trx_header_ID NOT IN
135: ( SELECT trx_header_id
136: FROM ar_trx_errors_gt );
137:
138: IF pg_debug = 'Y' THEN
139: ar_invoice_utils.debug('Rows Updated: ' || SQL%ROWCOUNT);
140: END IF;