55: return l_time_phase;
56: END get_lookup_time_phase;
57:
58: function get_resource_list_name
59: (p_resource_list_id IN pa_resource_lists.resource_list_id%TYPE)
60: return VARCHAR2 is
61: l_resource_list_name pa_resource_lists_tl.name%type;
62: BEGIN
63: select name
57:
58: function get_resource_list_name
59: (p_resource_list_id IN pa_resource_lists.resource_list_id%TYPE)
60: return VARCHAR2 is
61: l_resource_list_name pa_resource_lists_tl.name%type;
62: BEGIN
63: select name
64: into l_resource_list_name
65: from pa_resource_lists
61: l_resource_list_name pa_resource_lists_tl.name%type;
62: BEGIN
63: select name
64: into l_resource_list_name
65: from pa_resource_lists
66: where resource_list_id = p_resource_list_id;
67: return l_resource_list_name;
68: END get_resource_list_name;
69: