APPS.OKL_ACCT_SOURCES_PVT dependencies on OKL_TRX_CONTRACTS

Line 568: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;

564:
565:
566: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
567:
568: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
569: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
570:
571: CURSOR tcl_csr(v_source_id NUMBER) IS
572: SELECT tcn_id

Line 569: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;

565:
566: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
567:
568: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
569: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
570:
571: CURSOR tcl_csr(v_source_id NUMBER) IS
572: SELECT tcn_id
573: FROM OKL_TXL_CNTRCT_LNS

Line 578: FROM OKL_TRX_CONTRACTS

574: WHERE ID = v_source_id;
575:
576: CURSOR tcn_csr(v_tcn_id NUMBER) IS
577: SELECT tsu_code
578: FROM OKL_TRX_CONTRACTS
579: WHERE ID = v_tcn_id;
580:
581: BEGIN
582: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;