APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 1547: INSERT into zx_rep_trx_detail_t

1543: FORALL i IN 1 .. nvl(gt_ledger_id.COUNT, 0)
1544:
1545: -- New insert code
1546:
1547: INSERT into zx_rep_trx_detail_t
1548: (application_id,
1549: detail_tax_line_id,
1550: ledger_id,
1551: trx_id,

Line 2085: SELECT zx_rep_trx_detail_t_s.nextval

2081: END IF;
2082:
2083: IF zx_rep_detail_csr%FOUND THEN
2084:
2085: SELECT zx_rep_trx_detail_t_s.nextval
2086: INTO gt_detail_tax_line_id(i)
2087: FROM DUAL;
2088:
2089: --

Line 2219: FROM zx_rep_trx_detail_t det,

2215: DET.TAX_AMT,
2216: DET.TAX_AMT_FUNCL_CURR,
2217: ACT.ACTG_LINE_CCID,
2218: ACT.ACTG_EXT_LINE_ID
2219: FROM zx_rep_trx_detail_t det,
2220: zx_rep_actg_ext_t act
2221: WHERE det.extract_source_ledger = 'GL'
2222: AND det.request_id = c_request_id
2223: AND act.detail_tax_line_id(+) = det.detail_tax_line_id;

Line 2410: UPDATE ZX_REP_TRX_DETAIL_T SET

2406: END IF;
2407: END LOOP;
2408:
2409: FORALL i in 1..l_count
2410: UPDATE ZX_REP_TRX_DETAIL_T SET
2411: TAX_RATE_VAT_TRX_TYPE_DESC = GT_TAX_RATE_VAT_TRX_TYPE_DESC(i),
2412: TRX_CLASS_MNG = GT_TRX_CLASS_MNG(i),
2413: TAX_RATE_CODE_VAT_TRX_TYPE_MNG = GT_TAX_RATE_VAT_TRX_TYPE_MNG(i),
2414: TAX_TYPE_MNG = GT_TAX_TYPE_MNG(i),