DBA Data[Home] [Help]

APPS.PAY_JP_DATA_MIGRATION_PKG dependencies on HR_LEGISLATION_INSTALLATIONS

Line 5051: from hr_legislation_installations hli

5047: --
5048: cursor csr_hr_only
5049: is
5050: select 'Y'
5051: from hr_legislation_installations hli
5052: where hli.application_short_name = 'PER'
5053: and hli.legislation_code = 'JP'
5054: and nvl(hli.status,'X') = 'I'
5055: and not exists(

Line 5057: from hr_legislation_installations hli2

5053: and hli.legislation_code = 'JP'
5054: and nvl(hli.status,'X') = 'I'
5055: and not exists(
5056: select null
5057: from hr_legislation_installations hli2
5058: where hli2.application_short_name = 'PAY'
5059: and hli2.legislation_code = 'JP'
5060: and nvl(hli2.status,'X') = 'I');
5061: --

Line 6653: from hr_legislation_installations hli

6649: --
6650: cursor csr_pay_install
6651: is
6652: select 'Y'
6653: from hr_legislation_installations hli
6654: where hli.application_short_name = 'PAY'
6655: and hli.legislation_code = 'JP'
6656: and nvl(hli.status,'X') = 'I';
6657: --