APPS.OKL_TRNS_ACC_DSTRS_PUB dependencies on OKL_TRX_CONTRACTS

Line 700: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;

696:
697:
698: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
699:
700: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
701: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
702:
703: CURSOR tcl_csr(v_source_id NUMBER) IS
704: SELECT tcn_id

Line 701: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;

697:
698: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
699:
700: l_tcn_id OKL_TRX_CONTRACTS.ID%TYPE;
701: l_tsu_code OKL_TRX_CONTRACTS.TSU_CODE%TYPE;
702:
703: CURSOR tcl_csr(v_source_id NUMBER) IS
704: SELECT tcn_id
705: FROM OKL_TXL_CNTRCT_LNS

Line 710: FROM OKL_TRX_CONTRACTS

706: WHERE ID = v_source_id;
707:
708: CURSOR tcn_csr(v_tcn_id NUMBER) IS
709: SELECT tsu_code
710: FROM OKL_TRX_CONTRACTS
711: WHERE ID = v_tcn_id;
712: --
713: BEGIN
714: x_return_status := FND_API.G_RET_STS_SUCCESS;