APPS.OKL_MULTIGAAP_ENGINE_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 1220: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';

1216:
1217: /* variables */
1218: l_api_name CONSTANT VARCHAR2(40) := 'REVERSE_SEC_REP_TRX';
1219: l_api_version CONSTANT NUMBER := 1.0;
1220: l_source_table CONSTANT OKL_TRNS_ACC_DSTRS.SOURCE_TABLE%TYPE := 'OKL_TXL_CNTRCT_LNS';
1221: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1222: l_sysdate DATE := SYSDATE;
1223: l_reversal_date DATE;
1224: l_COUNT NUMBER :=0;

Line 1254: from okl_trns_acc_dstrs_all dst

1250: AND txl.tcn_id = p_tcn_id
1251: AND trx.tsu_code = 'PROCESSED'
1252: AND trx.representation_type = G_SECONDARY
1253: AND EXISTS (select 1 /* bug 14381856 */
1254: from okl_trns_acc_dstrs_all dst
1255: where dst.source_id = txl.id
1256: and dst.source_table = 'OKL_TXL_CNTRCT_LNS');
1257:
1258: BEGIN