DBA Data[Home] [Help]

APPS.OKC_COPY_CONTRACT_PVT dependencies on OKC_K_GRPINGS_V

Line 1350: FROM okc_k_grpings_v cgcv,

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

Line 7114: FROM OKC_K_GRPINGS_V

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