APPS.OKC_QUERY dependencies on OKC_K_GRPINGS

Line 177: -- DESCRIPTION: gets a count of the number of child groups in OKC_K_GRPINGS --

173:
174: --
175: -- ---------------------------------------------------------------------------------
176: -- FUNCTION: GetChildCount --
177: -- DESCRIPTION: gets a count of the number of child groups in OKC_K_GRPINGS --
178: -- using the recordid passed --
179: -- DEPENDENCIES: none --
180: -- CHANGE HISTORY: --
181: -- --

Line 191: from okc_k_grpings

187: /*
188: CURSOR cg(p_id IN NUMBER) IS
189: select
190: count(*)
191: from okc_k_grpings
192: where cgp_parent_id = p_id
193: and included_chr_id is NULL;
194: */
195: CURSOR cg(p_id IN NUMBER) IS

Line 198: from okc_k_grpings

194: */
195: CURSOR cg(p_id IN NUMBER) IS
196: select /*+ FIRST_ROWS */
197: 1
198: from okc_k_grpings
199: where cgp_parent_id = p_id
200: and included_cgp_id is NOT NULL;
201: ret NUMBER;
202:

Line 432: from okc_k_grpings, okc_k_groups_v g

428: RETURN VARCHAR2 IS
429:
430: CURSOR cg(p_contract_id IN NUMBER) IS
431: select g.name
432: from okc_k_grpings, okc_k_groups_v g
433: where included_chr_id = p_contract_id
434: and cgp_parent_id = g.id and
435: ((g.public_YN = 'Y') or
436: (g.public_YN = 'N' and user_id = FND_GLOBAL.USER_ID));