[Home] [Help]
2890: CURSOR c_draft_csr IS
2891: SELECT
2892: DIST.POST_TO_GL
2893: FROM
2894: OKL_TXL_CNTRCT_LNS LN,
2895: OKL_TRNS_ACC_DSTRS DIST
2896: WHERE
2897: LN.TCN_ID = p_trx_id
2898: AND LN.ID = DIST.SOURCE_ID
2917: BEGIN
2918:
2919: -- If the transaction is a contract transaction
2920:
2921: IF p_source_table = 'OKL_TXL_CNTRCT_LNS' THEN
2922:
2923: OPEN c_draft_csr;
2924: FETCH c_draft_csr INTO l_draft;
2925: IF c_draft_csr%NOTFOUND THEN