839: end set_client_info;
840:
841: FUNCTION get_noa_code (p_nature_of_action_id IN NUMBER)
842: RETURN VARCHAR2 AS
843: l_noa_code ghr_nature_of_actions.code%type;
844: cursor c_noa_code is select code from ghr_nature_of_actions
845: where nature_of_action_id= p_nature_of_action_id;
846: BEGIN
847: open c_noa_code ;
840:
841: FUNCTION get_noa_code (p_nature_of_action_id IN NUMBER)
842: RETURN VARCHAR2 AS
843: l_noa_code ghr_nature_of_actions.code%type;
844: cursor c_noa_code is select code from ghr_nature_of_actions
845: where nature_of_action_id= p_nature_of_action_id;
846: BEGIN
847: open c_noa_code ;
848: fetch c_noa_code into l_noa_code;