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));