DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on OKC_K_GRPINGS_V

Line 551: FROM okc_k_grpings_v cgcv,

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

Line 2443: FROM OKC_K_GRPINGS_V

2439: SELECT ID,
2440: CGP_PARENT_ID,
2441: INCLUDED_CHR_ID,
2442: INCLUDED_CGP_ID
2443: FROM OKC_K_GRPINGS_V
2444: WHERE ID = p_cgc_id;
2445:
2446: BEGIN
2447: OPEN c_cgcv_rec;