DBA Data[Home] [Help]

APPS.OKS_RENCPY_PVT dependencies on OKC_K_GRPINGS_V

Line 472: FROM okc_k_grpings_v cgcv,

468: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
469:
470: CURSOR c_grpings IS
471: SELECT cgcv.id
472: FROM okc_k_grpings_v cgcv,
473: okc_k_groups_b cgpv
474: WHERE cgcv.included_chr_id = p_from_chr_id
475: AND cgcv.cgp_parent_id = cgpv.id
476: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);

Line 2809: FROM OKC_K_GRPINGS_V

2805: SELECT ID,
2806: CGP_PARENT_ID,
2807: INCLUDED_CHR_ID,
2808: INCLUDED_CGP_ID
2809: FROM OKC_K_GRPINGS_V
2810: WHERE ID = p_cgc_id;
2811: BEGIN
2812: OPEN c_cgcv_rec;
2813: FETCH c_cgcv_rec