856: end set_client_info;
857:
858: FUNCTION get_noa_code (p_nature_of_action_id IN NUMBER)
859: RETURN VARCHAR2 AS
860: l_noa_code ghr_nature_of_actions.code%type;
861: cursor c_noa_code is select code from ghr_nature_of_actions
862: where nature_of_action_id= p_nature_of_action_id;
863: BEGIN
864: open c_noa_code ;
857:
858: FUNCTION get_noa_code (p_nature_of_action_id IN NUMBER)
859: RETURN VARCHAR2 AS
860: l_noa_code ghr_nature_of_actions.code%type;
861: cursor c_noa_code is select code from ghr_nature_of_actions
862: where nature_of_action_id= p_nature_of_action_id;
863: BEGIN
864: open c_noa_code ;
865: fetch c_noa_code into l_noa_code;