APPS.OKL_RCS_PVT dependencies on OKL_FE_RESI_CAT_V

Line 187: -- Procedure get_rec for OKL_FE_RESI_CAT_V

183: RETURN(get_rec(p_rcstl_rec,l_row_notfound));
184: END get_rec;
185:
186: --------------------------------------------------------------------------------
187: -- Procedure get_rec for OKL_FE_RESI_CAT_V
188: --------------------------------------------------------------------------------
189:
190: FUNCTION get_rec(
191: p_rcsv_rec IN okl_rcsv_rec,

Line 210: FROM OKL_FE_RESI_CAT_V WHERE OKL_FE_RESI_CAT_V.resi_category_set_id=p_id;

206: CREATION_DATE,
207: LAST_UPDATED_BY,
208: LAST_UPDATE_DATE,
209: LAST_UPDATE_LOGIN
210: FROM OKL_FE_RESI_CAT_V WHERE OKL_FE_RESI_CAT_V.resi_category_set_id=p_id;
211: l_rcsv_pk rcsv_pk_csr%ROWTYPE;
212: l_rcsv_rec okl_rcsv_rec;
213: BEGIN
214: x_no_data_found:= TRUE;

Line 385: OKL_FE_RESI_CAT_V RCS_B

381: SELECT
382: RESI_CATEGORY_SET_ID
383: FROM
384: -- viselvar Bug 4860445 modified start
385: OKL_FE_RESI_CAT_V RCS_B
386: -- viselvar Bug 4860445 modifield end
387: WHERE
388: RCS_B.RESI_CAT_NAME = p_rcsb_rec.resi_cat_name;
389: