APPS.OKL_ACCOUNT_DIST_MISC_PVT dependencies on OKL_TRX_CONTRACTS

Line 35: FROM OKL_TRX_CONTRACTS

31: currency_code,
32: currency_conversion_date,
33: currency_conversion_rate,
34: currency_conversion_type
35: FROM OKL_TRX_CONTRACTS
36: WHERE ID IN (SELECT TCN_ID
37: FROM OKL_TXL_CNTRCT_LNS
38: WHERE ID = v_source_id);
39:

Line 386: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;

382: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
383:
384: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
385:
386: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
387: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
388:
389: CURSOR tcl_csr(v_source_id NUMBER) IS
390: SELECT tcn_id

Line 387: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;

383:
384: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
385:
386: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
387: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
388:
389: CURSOR tcl_csr(v_source_id NUMBER) IS
390: SELECT tcn_id
391: FROM OKL_TXL_CNTRCT_LNS

Line 396: FROM OKL_TRX_CONTRACTS

392: WHERE ID = v_source_id;
393:
394: CURSOR tcn_csr(v_tcn_id NUMBER) IS
395: SELECT tsu_code
396: FROM OKL_TRX_CONTRACTS
397: WHERE ID = v_tcn_id;
398:
399:
400: BEGIN