APPS.OKC_CONTRACT_GROUP_PVT dependencies on OKC_K_GRPINGS

Line 280: FROM OKC_K_GRPINGS

276: p_cgpv_rec IN cgpv_rec_type
277: ) RETURN VARCHAR2 IS
278: CURSOR okc_cgcv_included_csr (p_included_cgp_id IN NUMBER) IS
279: SELECT id
280: FROM OKC_K_GRPINGS
281: WHERE included_cgp_id = p_included_cgp_id;
282: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
283: l_index NUMBER := 1;
284: l_cgcv_tbl okc_contract_group_pub.cgcv_tbl_type;

Line 322: FROM OKC_K_GRPINGS

318: ) RETURN VARCHAR2 IS
319: child_record_error EXCEPTION;
320: CURSOR okc_cgcv_parent_csr (p_cgp_parent_id IN NUMBER) IS
321: SELECT id
322: FROM OKC_K_GRPINGS
323: WHERE cgp_parent_id = p_cgp_parent_id;
324: l_dummy VARCHAR2(1);
325: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
326: l_row_found BOOLEAN := FALSE;

Line 510: FROM OKC_K_GRPINGS

506: recursive_error EXCEPTION;
507: CURSOR okc_cgcv_csr (p_cgp_parent_id IN NUMBER,
508: p_included_cgp_id IN NUMBER) IS
509: SELECT 'x'
510: FROM OKC_K_GRPINGS
511: WHERE included_cgp_id = p_cgp_parent_id
512: START WITH cgp_parent_id = p_included_cgp_id
513: CONNECT BY PRIOR included_cgp_id = cgp_parent_id;
514: l_dummy VARCHAR2(1);