DBA Data[Home] [Help]

APPS.HR_LEG_INSTALLATION_PKG dependencies on FND_PRODUCT_INSTALLATIONS

Line 168: from fnd_product_installations

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

Line 173: from fnd_product_installations

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

Line 178: from fnd_product_installations

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