DBA Data[Home] [Help]

APPS.OKL_RCS_PVT dependencies on OKL_FE_RESI_CAT_V

Line 177: -- Procedure get_rec for OKL_FE_RESI_CAT_V

173: RETURN(get_rec(p_rcstl_rec,l_row_notfound));
174: END get_rec;
175:
176: --------------------------------------------------------------------------------
177: -- Procedure get_rec for OKL_FE_RESI_CAT_V
178: --------------------------------------------------------------------------------
179:
180: FUNCTION get_rec(
181: p_rcsv_rec IN okl_rcsv_rec,

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

196: CREATION_DATE,
197: LAST_UPDATED_BY,
198: LAST_UPDATE_DATE,
199: LAST_UPDATE_LOGIN
200: FROM OKL_FE_RESI_CAT_V WHERE OKL_FE_RESI_CAT_V.resi_category_set_id=p_id;
201: l_rcsv_pk rcsv_pk_csr%ROWTYPE;
202: l_rcsv_rec okl_rcsv_rec;
203: BEGIN
204: x_no_data_found:= TRUE;

Line 375: OKL_FE_RESI_CAT_V RCS_B

371: SELECT
372: RESI_CATEGORY_SET_ID
373: FROM
374: -- viselvar Bug 4860445 modified start
375: OKL_FE_RESI_CAT_V RCS_B
376: -- viselvar Bug 4860445 modifield end
377: WHERE
378: RCS_B.RESI_CAT_NAME = p_rcsb_rec.resi_cat_name;
379: