APPS.OKC_DBTREE_PVT dependencies on OKC_K_GROUPS_V

Line 359: from okc_k_groups_v g

355: public_yn,
356: created_by,
357: creation_date,
358: okc_query.GetChildCount(id) numchildren
359: from okc_k_groups_v g
360: where NOT EXISTS (select 1
361: from okc_k_grpings_v p
362: where p.included_cgp_id = g.id)
363: AND ( (g.public_yn = decode(gflag,'U','Y',gflag,'A','Y'))

Line 379: from okc_k_groups_v g

375: public_yn,
376: created_by,
377: creation_date,
378: okc_query.GetChildCount(id) numchildren
379: from okc_k_groups_v g
380: where NOT EXISTS (select 1
381: from okc_k_grpings_v p
382: where p.included_cgp_id = g.id)
383: AND ( (g.public_yn = decode(gflag,'U','Y','A','Y'))

Line 400: from okc_k_groups_v g

396: public_yn,
397: created_by,
398: creation_date,
399: okc_query.GetChildCount(id) numchildren
400: from okc_k_groups_v g
401: where NOT EXISTS (
402: select 1
403: from okc_k_grpings_v p, okc_k_groups_v g1
404: where p.included_cgp_id = g.id

Line 403: from okc_k_grpings_v p, okc_k_groups_v g1

399: okc_query.GetChildCount(id) numchildren
400: from okc_k_groups_v g
401: where NOT EXISTS (
402: select 1
403: from okc_k_grpings_v p, okc_k_groups_v g1
404: where p.included_cgp_id = g.id
405: and g1.id = p.cgp_parent_id
406: and g1.public_yn = 'Y'
407:

Line 411: from okc_k_grpings_v p, okc_k_groups_v g1

407:
408: UNION
409:
410: select 1
411: from okc_k_grpings_v p, okc_k_groups_v g1
412: where p.included_cgp_id = g.id
413: and g1.id = p.cgp_parent_id
414: AND g1.public_yn = 'N' and g1.user_id = FND_GLOBAL.USER_ID
415: )