DBA Data[Home] [Help]

APPS.OKC_QUERY_PVT dependencies on OKC_K_GRPINGS

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

140:
141: --
142: -- ---------------------------------------------------------------------------------
143: -- FUNCTION: GetChildCount --
144: -- DESCRIPTION: gets a count of the number of child groups in OKC_K_GRPINGS --
145: -- using the recordid passed --
146: -- DEPENDENCIES: none --
147: -- CHANGE HISTORY: --
148: -- --

Line 157: from okc_k_grpings

153: RETURN NUMBER IS
154:
155: CURSOR cg(p_id IN NUMBER) IS
156: select count(*)
157: from okc_k_grpings
158: where cgp_parent_id = p_id;
159: ret NUMBER;
160:
161: BEGIN