DBA Data[Home] [Help]

APPS.PAY_IP_STARTUP_UTIL dependencies on HR_LEGISLATION_INSTALLATIONS

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

295: l_reference number := 0;
296:
297: BEGIN
298: hr_utility.set_location('pay_ip_startup_util.check_to_install',10);
299: --Returns TRUE if the HR_LEGISLATION_INSTALLATIONS do not have PAY or PER
300: --for the given legislation and if no other patch is getting applied
301: --and reference data is available.
302:
303: IF pay_ip_utility.IS_release_122_plus THEN

Line 309: FROM hr_legislation_installations

305: END IF;
306:
307: SELECT count(application_short_name)
308: INTO l_Installed
309: FROM hr_legislation_installations
310: WHERE application_short_name IN('PAY','PER')
311: AND legislation_code = p_legislation_code;
312:
313: IF l_installed > 0 THEN

Line 322: FROM hr_legislation_installations

318: END IF;
319:
320: SELECT count(application_short_name)
321: INTO l_Installed
322: FROM hr_legislation_installations
323: WHERE action IS NOT NULL;
324:
325: IF l_installed > 0 THEN
326: g_logging := 'Y';