DBA Data[Home] [Help]

APPS.AR_TRX_GLOBAL_PROCESS_TMP dependencies on AR_TRX_LINES_TMP_GT

Line 293: INSERT INTO ar_trx_lines_tmp_gt

289: IF RecExist >= 1
290: THEN
291: FOR i IN p_trx_lines_tbl.FIRST .. p_trx_lines_tbl.LAST
292: LOOP
293: INSERT INTO ar_trx_lines_tmp_gt
294: ( TRX_HEADER_ID,
295: TRX_LINE_ID,
296: LINK_TO_TRX_LINE_ID,
297: LINE_NUMBER,

Line 701: from ar_trx_lines_tmp_gt

697: where nvl(org_id,-99) = nvl(p_org_id,-99);
698:
699: cursor ln_cur (P_TRX_HEADER_ID number) is
700: select *
701: from ar_trx_lines_tmp_gt
702: where TRX_HEADER_ID = P_TRX_HEADER_ID;
703:
704: /* 4652982 - Modified to only insert line-level dists */
705: cursor dist_cur (P_TRX_LINE_ID number ) is