164: begin
165: --set hr_installed variable
166: select count(*)
167: into hr_installed
168: from fnd_product_installations
169: where application_id=800 and status='I';
170: --set pay_installed variable
171: select count(*)
172: into pay_installed
169: where application_id=800 and status='I';
170: --set pay_installed variable
171: select count(*)
172: into pay_installed
173: from fnd_product_installations
174: where application_id=801 and status='I';
175: --set ghr_installed variable
176: select count(*)
177: into ghr_installed
174: where application_id=801 and status='I';
175: --set ghr_installed variable
176: select count(*)
177: into ghr_installed
178: from fnd_product_installations
179: where application_id=8301 and status='I';
180: --
181: -- set ghr row
182: if ghr_installed <> 0 then