APPS.CN_API dependencies on CN_COMP_GROUPS

Line 1909: RETURN cn_comp_groups.name%TYPE IS

1905: --| Function Name : get_comp_group_name
1906: --| Desc : Pass in comp_group id then return comp_group name
1907: --| ---------------------------------------------------------------------=
1908: FUNCTION get_comp_group_name( p_comp_group_id NUMBER)
1909: RETURN cn_comp_groups.name%TYPE IS
1910:
1911: l_comp_group_name cn_comp_groups.name%TYPE;
1912:
1913: BEGIN

Line 1911: l_comp_group_name cn_comp_groups.name%TYPE;

1907: --| ---------------------------------------------------------------------=
1908: FUNCTION get_comp_group_name( p_comp_group_id NUMBER)
1909: RETURN cn_comp_groups.name%TYPE IS
1910:
1911: l_comp_group_name cn_comp_groups.name%TYPE;
1912:
1913: BEGIN
1914: SELECT name
1915: INTO l_comp_group_name

Line 1916: FROM cn_comp_groups

1912:
1913: BEGIN
1914: SELECT name
1915: INTO l_comp_group_name
1916: FROM cn_comp_groups
1917: WHERE comp_group_id = p_comp_group_id;
1918:
1919: RETURN l_comp_group_name;
1920: