APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_SLCTD_OPTNS_V

Line 1318: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V

1314: --Bug# 4558486
1315:
1316: --Bug # 3630858
1317: ---------------------------------------------------------------------------
1318: -- FUNCTION get_rec for: OKL_SLCTD_OPTNS_V
1319: ---------------------------------------------------------------------------
1320: FUNCTION get_cspv_rec (
1321: p_cspv_rec_id IN number,
1322: x_return_status OUT NOCOPY VARCHAR2

Line 1351: FROM OKL_SLCTD_OPTNS_V

1347: CREATION_DATE,
1348: LAST_UPDATED_BY,
1349: LAST_UPDATE_DATE,
1350: LAST_UPDATE_LOGIN
1351: FROM OKL_SLCTD_OPTNS_V
1352: WHERE OKL_SLCTD_OPTNS_V.id = p_id;
1353:
1354: l_cspv_rec_id number;
1355: l_cspv_rec cspv_rec_type;

Line 1352: WHERE OKL_SLCTD_OPTNS_V.id = p_id;

1348: LAST_UPDATED_BY,
1349: LAST_UPDATE_DATE,
1350: LAST_UPDATE_LOGIN
1351: FROM OKL_SLCTD_OPTNS_V
1352: WHERE OKL_SLCTD_OPTNS_V.id = p_id;
1353:
1354: l_cspv_rec_id number;
1355: l_cspv_rec cspv_rec_type;
1356: l_no_data_found BOOLEAN := FALSE;

Line 2911: from OKL_SLCTD_OPTNS_V cspv

2907:
2908: -- Bug 3630858
2909: cursor l_product_options_csr(p_old_chr_id number) IS
2910: select cspv.id
2911: from OKL_SLCTD_OPTNS_V cspv
2912: where cspv.khr_id = p_old_chr_id;
2913:
2914: l_pyd_id okl_party_payment_dtls.ID%TYPE;
2915: lx_pyd_id okl_party_payment_dtls.ID%TYPE;

Line 2918: l_cspv_id okl_slctd_optns_v.ID%TYPE;

2914: l_pyd_id okl_party_payment_dtls.ID%TYPE;
2915: lx_pyd_id okl_party_payment_dtls.ID%TYPE;
2916: l_cpl_id okc_k_party_roles_b.ID%TYPE;
2917: -- Bug 3630858
2918: l_cspv_id okl_slctd_optns_v.ID%TYPE;
2919: lx_cspv_id okl_slctd_optns_v.ID%TYPE;
2920:
2921: ---------------------
2922: --Bug# 3143522

Line 2919: lx_cspv_id okl_slctd_optns_v.ID%TYPE;

2915: lx_pyd_id okl_party_payment_dtls.ID%TYPE;
2916: l_cpl_id okc_k_party_roles_b.ID%TYPE;
2917: -- Bug 3630858
2918: l_cspv_id okl_slctd_optns_v.ID%TYPE;
2919: lx_cspv_id okl_slctd_optns_v.ID%TYPE;
2920:
2921: ---------------------
2922: --Bug# 3143522
2923: -----------------------