[Home] [Help]
173: ZX_ACTG.ACTG_EVENT_ID,
174: -- ZX_ACTG.ACTG_ENTITY_ID,
175: ZX_ACTG.ACTG_LINE_CCID
176: FROM zx_rep_trx_detail_t zx_dtl,
177: zx_rep_actg_ext_t zx_actg
178: WHERE zx_dtl.request_id = c_request_id
179: AND zx_dtl.extract_source_ledger = 'AP'
180: AND zx_dtl.detail_tax_line_id = zx_actg.detail_tax_line_id;
181:
1635: 'ZX_AR_ACTG_POPULATE_PKG: UPDATE_REP_ACTG_T(+)');
1636: END IF;
1637:
1638: FORALL i in 1..p_count
1639: UPDATE zx_rep_actg_ext_t SET
1640: TRX_ARAP_BALANCING_SEGMENT = GT_TRX_ARAP_BALANCING_SEGMENT(i),
1641: TRX_ARAP_NATURAL_ACCOUNT = GT_TRX_ARAP_NATURAL_ACCOUNT(i),
1642: TRX_TAXABLE_BALANCING_SEGMENT = GT_TRX_TAXABLE_BAL_SEG(i),
1643: TRX_TAXABLE_NATURAL_ACCOUNT = GT_TRX_TAXABLE_NATURAL_ACCOUNT(i),