DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_GRPINGS_V

Line 1351: FROM okc_k_grpings_v cgcv,

1347: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1348:
1349: CURSOR c_grpings IS
1350: SELECT cgcv.id
1351: FROM okc_k_grpings_v cgcv,
1352: okc_k_groups_b cgpv
1353: WHERE cgcv.included_chr_id = p_from_chr_id
1354: AND cgcv.cgp_parent_id = cgpv.id
1355: AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);

Line 7115: FROM OKC_K_GRPINGS_V

7111: SELECT ID,
7112: CGP_PARENT_ID,
7113: INCLUDED_CHR_ID,
7114: INCLUDED_CGP_ID
7115: FROM OKC_K_GRPINGS_V
7116: WHERE ID = p_cgc_id;
7117:
7118: BEGIN
7119: OPEN c_cgcv_rec;