APPS.OKL_CLL_PVT dependencies on OKL_CNTR_LVLNG_GRPS_B

Line 578: FROM Okl_Cntr_Lvlng_Grps_B

574: AND ID <> cp_cll_id;
575:
576: CURSOR c_cntr_csr (p_id IN NUMBER) IS
577: SELECT effective_date_from,effective_date_to
578: FROM Okl_Cntr_Lvlng_Grps_B
579: WHERE okl_cntr_lvlng_grps_b.id = p_id;
580:
581: CURSOR c_conscounter_csr(cp_clg_id IN NUMBER,cp_counter IN NUMBER) IS
582: SELECT b.effective_date_from,b.effective_date_to,b.id,b.name

Line 579: WHERE okl_cntr_lvlng_grps_b.id = p_id;

575:
576: CURSOR c_cntr_csr (p_id IN NUMBER) IS
577: SELECT effective_date_from,effective_date_to
578: FROM Okl_Cntr_Lvlng_Grps_B
579: WHERE okl_cntr_lvlng_grps_b.id = p_id;
580:
581: CURSOR c_conscounter_csr(cp_clg_id IN NUMBER,cp_counter IN NUMBER) IS
582: SELECT b.effective_date_from,b.effective_date_to,b.id,b.name
583: FROM OKL_CNTR_LVLNG_LNS_B a,

Line 604: FROM Okl_Cntr_Lvlng_Grps_B

600: ) RETURN VARCHAR2 IS
601: item_not_found_error EXCEPTION;
602: CURSOR okl_cllv_clg_fk_csr (p_id IN NUMBER) IS
603: SELECT 'x'
604: FROM Okl_Cntr_Lvlng_Grps_B
605: WHERE okl_cntr_lvlng_grps_b.id = p_id;
606: l_okl_cllv_clg_fk okl_cllv_clg_fk_csr%ROWTYPE;
607:
608: CURSOR okl_cllv_kle_fk_csr (p_id IN NUMBER) IS

Line 605: WHERE okl_cntr_lvlng_grps_b.id = p_id;

601: item_not_found_error EXCEPTION;
602: CURSOR okl_cllv_clg_fk_csr (p_id IN NUMBER) IS
603: SELECT 'x'
604: FROM Okl_Cntr_Lvlng_Grps_B
605: WHERE okl_cntr_lvlng_grps_b.id = p_id;
606: l_okl_cllv_clg_fk okl_cllv_clg_fk_csr%ROWTYPE;
607:
608: CURSOR okl_cllv_kle_fk_csr (p_id IN NUMBER) IS
609: SELECT 'x'