10: GHR_STATUS_INSTALLED constant varchar2(2):='I';
11:
12: cursor csr_ghr_installed is
13: select status
14: from fnd_product_installations
15: where application_id = GHR_APPLICATION_ID;
16:
17: l_installed fnd_product_installations.status%type;
18: l_result varchar2(10) ;
13: select status
14: from fnd_product_installations
15: where application_id = GHR_APPLICATION_ID;
16:
17: l_installed fnd_product_installations.status%type;
18: l_result varchar2(10) ;
19:
20: BEGIN
21: l_result := 'FALSE';