605: GHR_STATUS_INSTALLED constant varchar2(2):='I';
606:
607: cursor csr_ghr_installed is
608: select status
609: from fnd_product_installations
610: where application_id = GHR_APPLICATION_ID;
611:
612: l_installed fnd_product_installations.status%type;
613: l_result varchar2(10) ;
608: select status
609: from fnd_product_installations
610: where application_id = GHR_APPLICATION_ID;
611:
612: l_installed fnd_product_installations.status%type;
613: l_result varchar2(10) ;
614:
615: BEGIN
616: l_result := 'FALSE';