DBA Data[Home] [Help]

APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on OKL_TRNS_ACC_DSTRS

Line 836: FROM OKL_TRNS_ACC_DSTRS DST

832: -- make sure we get the debit distribution and also it is 100percent
833: CURSOR code_combination_id_csr(p_source_id IN NUMBER,
834: p_source_table IN VARCHAR2) IS
835: SELECT DST.code_combination_id
836: FROM OKL_TRNS_ACC_DSTRS DST
837: WHERE DST.source_id = p_source_id
838: AND DST.source_table = p_source_table
839: AND DST.cr_dr_flag = 'D'
840: AND DST.percentage = 100;

Line 1420: -- from OKL_TRNS_ACC_DSTRS_V

1416: LOOP
1417: IF l_account_derivation = 'ATS' THEN
1418: -- *** GET CCID FROM ACCOUNTING DISTRIBUTIONS **** START *******
1419: -- Get the first code_combination_id for the transaction
1420: -- from OKL_TRNS_ACC_DSTRS_V
1421: OPEN code_combination_id_csr(ajlv_id_tbl(i).id, 'OKL_TXL_ADJSTS_LNS_B');
1422: FETCH code_combination_id_csr INTO l_code_combination_id;
1423: CLOSE code_combination_id_csr;
1424: -- if code_combination_id not found then raise error