1927: --| Function Name : get_comp_group_name
1928: --| Desc : Pass in comp_group id then return comp_group name
1929: --| ---------------------------------------------------------------------=
1930: FUNCTION get_comp_group_name( p_comp_group_id NUMBER)
1931: RETURN cn_comp_groups.name%TYPE IS
1932:
1933: l_comp_group_name cn_comp_groups.name%TYPE;
1934:
1935: BEGIN
1929: --| ---------------------------------------------------------------------=
1930: FUNCTION get_comp_group_name( p_comp_group_id NUMBER)
1931: RETURN cn_comp_groups.name%TYPE IS
1932:
1933: l_comp_group_name cn_comp_groups.name%TYPE;
1934:
1935: BEGIN
1936: SELECT name
1937: INTO l_comp_group_name
1934:
1935: BEGIN
1936: SELECT name
1937: INTO l_comp_group_name
1938: FROM cn_comp_groups
1939: WHERE comp_group_id = p_comp_group_id;
1940:
1941: RETURN l_comp_group_name;
1942: