DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_GRPINGS_V

Line 553: FROM okc_k_grpings_v cgcv,

549: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
550:
551: CURSOR c_grpings IS
552: SELECT cgcv.id
553: FROM okc_k_grpings_v cgcv,
554: okc_k_groups_b cgpv
555: WHERE cgcv.included_chr_id = p_from_chr_id
556: AND cgcv.cgp_parent_id = cgpv.id
557: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);

Line 2480: FROM OKC_K_GRPINGS_V

2476: SELECT ID,
2477: CGP_PARENT_ID,
2478: INCLUDED_CHR_ID,
2479: INCLUDED_CGP_ID
2480: FROM OKC_K_GRPINGS_V
2481: WHERE ID = p_cgc_id;
2482:
2483: BEGIN
2484: OPEN c_cgcv_rec;