607:
608: end hrms_object;
609: -------------------------------------------------------------------------
610: function get_application_short_name (p_application_id in varchar2) return varchar2 is
611: l_return_value fnd_application.application_short_name%type ;
612: cursor c1 (p_app_id in number ) is
613: select fa.application_short_name
614: from fnd_application fa
615: where fa.application_id = p_app_id ;
610: function get_application_short_name (p_application_id in varchar2) return varchar2 is
611: l_return_value fnd_application.application_short_name%type ;
612: cursor c1 (p_app_id in number ) is
613: select fa.application_short_name
614: from fnd_application fa
615: where fa.application_id = p_app_id ;
616: begin
617:
618: -- Special case the most common ones. This is to save a select