DBA Data[Home] [Help]

APPS.AR_TRX_GLOBAL_PROCESS_TMP dependencies on AR_TRX_DIST_TMP_GT

Line 546: INSERT INTO ar_trx_dist_tmp_gt

542: IF RecExist >= 1
543: THEN
544: FOR i IN p_trx_dist_tbl.FIRST .. p_trx_dist_tbl.LAST
545: LOOP
546: INSERT INTO ar_trx_dist_tmp_gt
547: ( TRX_DIST_ID,
548: TRX_HEADER_ID,
549: TRX_LINE_ID,
550: ACCOUNT_CLASS,

Line 707: from ar_trx_dist_tmp_gt

703:
704: /* 4652982 - Modified to only insert line-level dists */
705: cursor dist_cur (P_TRX_LINE_ID number ) is
706: select *
707: from ar_trx_dist_tmp_gt
708: where TRX_LINE_ID = P_TRX_LINE_ID;
709:
710: /* 4652982 - Added to insert header-level dists */
711: cursor dist_rec_cur (P_TRX_HEADER_ID number) is

Line 713: from ar_trx_dist_tmp_gt

709:
710: /* 4652982 - Added to insert header-level dists */
711: cursor dist_rec_cur (P_TRX_HEADER_ID number) is
712: select *
713: from ar_trx_dist_tmp_gt
714: where TRX_HEADER_ID = P_TRX_HEADER_ID
715: and TRX_LINE_ID is NULL;
716:
717: cursor sc_cur (P_TRX_HEADER_ID number, P_TRX_LINE_ID number) is