APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_SLCTD_OPTNS_V

Line 1336: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V

1332: --Bug# 4558486
1333:
1334: --Bug # 3630858
1335: ---------------------------------------------------------------------------
1336: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V
1337: ---------------------------------------------------------------------------
1338: FUNCTION get_cspv_rec (
1339: p_cspv_rec_id IN number,
1340: x_return_status OUT NOCOPY VARCHAR2

Line 1369: FROM OKL_SLCTD_OPTNS_V

1365: CREATION_DATE,
1366: LAST_UPDATED_BY,
1367: LAST_UPDATE_DATE,
1368: LAST_UPDATE_LOGIN
1369: FROM OKL_SLCTD_OPTNS_V
1370: WHERE OKL_SLCTD_OPTNS_V.id = p_id;
1371:
1372: l_cspv_rec_id number;
1373: l_cspv_rec cspv_rec_type;

Line 1370: WHERE OKL_SLCTD_OPTNS_V.id = p_id;

1366: LAST_UPDATED_BY,
1367: LAST_UPDATE_DATE,
1368: LAST_UPDATE_LOGIN
1369: FROM OKL_SLCTD_OPTNS_V
1370: WHERE OKL_SLCTD_OPTNS_V.id = p_id;
1371:
1372: l_cspv_rec_id number;
1373: l_cspv_rec cspv_rec_type;
1374: l_no_data_found BOOLEAN := FALSE;

Line 2948: from OKL_SLCTD_OPTNS_V cspv

2944:
2945: -- Bug 3630858
2946: cursor l_product_options_csr(p_old_chr_id number) IS
2947: select cspv.id
2948: from OKL_SLCTD_OPTNS_V cspv
2949: where cspv.khr_id = p_old_chr_id;
2950:
2951: l_pyd_id okl_party_payment_dtls.ID%TYPE;
2952: lx_pyd_id okl_party_payment_dtls.ID%TYPE;

Line 2955: l_cspv_id okl_slctd_optns_v.ID%TYPE;

2951: l_pyd_id okl_party_payment_dtls.ID%TYPE;
2952: lx_pyd_id okl_party_payment_dtls.ID%TYPE;
2953: l_cpl_id okc_k_party_roles_b.ID%TYPE;
2954: -- Bug 3630858
2955: l_cspv_id okl_slctd_optns_v.ID%TYPE;
2956: lx_cspv_id okl_slctd_optns_v.ID%TYPE;
2957:
2958: ---------------------
2959: --Bug# 3143522

Line 2956: lx_cspv_id okl_slctd_optns_v.ID%TYPE;

2952: lx_pyd_id okl_party_payment_dtls.ID%TYPE;
2953: l_cpl_id okc_k_party_roles_b.ID%TYPE;
2954: -- Bug 3630858
2955: l_cspv_id okl_slctd_optns_v.ID%TYPE;
2956: lx_cspv_id okl_slctd_optns_v.ID%TYPE;
2957:
2958: ---------------------
2959: --Bug# 3143522
2960: -----------------------