APPS.PAY_IP_STARTUP_UTIL dependencies on HR_LEGISLATION_INSTALLATIONS

Line 293: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER

289: l_reference number := 0;
290:
291: BEGIN
292: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
293: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
294: --for the given legislation and if no other patch is getting applied
295: --and reference data is available.
296:
297: SELECT count(*)

Line 299: FROM hr_legislation_installations

295: --and reference data is available.
296:
297: SELECT count(*)
298: INTO l_Installed
299: FROM hr_legislation_installations
300: WHERE application_short_name IN('PAY','PER')
301: AND legislation_code = p_legislation_code;
302:
303: IF l_installed > 0 THEN

Line 312: FROM hr_legislation_installations

308: END IF;
309:
310: SELECT count(*)
311: INTO l_Installed
312: FROM hr_legislation_installations
313: WHERE action IS NOT NULL;
314:
315: IF l_installed > 0 THEN
316: g_logging := 'Y';