eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_ISDF_ARCHIVE_PKG dependencies on HR_API

Line 1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1227: and paei.information_type = 'JP_ASS_LIG_INFO'
1228: -- include PC for customized valuset
1229: --and paei.aei_information1 in ('GIP','LINC')
1230: and g_effective_date
1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1233: and hoi.org_information1 = paei.aei_information2
1234: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION12,'O')
1235: and hoi.org_information_context

Line 1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1228: -- include PC for customized valuset
1229: --and paei.aei_information1 in ('GIP','LINC')
1230: and g_effective_date
1231: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1232: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1233: and hoi.org_information1 = paei.aei_information2
1234: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION12,'O')
1235: and hoi.org_information_context
1236: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1283: and paei.information_type = 'JP_ASS_CMI_INFO'
1284: -- include PC for customized valuset
1285: --and paei.aei_information1 in ('GIP','LINC')
1286: and g_effective_date
1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1289: and hoi.org_information1 = paei.aei_information2
1290: and nvl(hoi.ORG_INFORMATION10,'N') = 'N'
1291: and hoi.org_information_context

Line 1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1284: -- include PC for customized valuset
1285: --and paei.aei_information1 in ('GIP','LINC')
1286: and g_effective_date
1287: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1288: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1289: and hoi.org_information1 = paei.aei_information2
1290: and nvl(hoi.ORG_INFORMATION10,'N') = 'N'
1291: and hoi.org_information_context
1292: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1339: and paei.information_type = 'JP_ASS_LIP_INFO'
1340: -- include PC for customized valuset
1341: --and paei.aei_information1 in ('GIP','LINC')
1342: and g_effective_date
1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1345: and hoi.org_information1 = paei.aei_information2
1346: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION13,'O')
1347: and hoi.org_information_context

Line 1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1340: -- include PC for customized valuset
1341: --and paei.aei_information1 in ('GIP','LINC')
1342: and g_effective_date
1343: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1344: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1345: and hoi.org_information1 = paei.aei_information2
1346: and nvl(hoi.ORG_INFORMATION10,'O') = nvl(paei.AEI_INFORMATION13,'O')
1347: and hoi.org_information_context
1348: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

Line 1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1393: -- include PC for customized valuset
1394: --and paei.aei_information13 = 'AP'
1395: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1396: and g_effective_date
1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1399: and hoi.org_information1 = paei.aei_information2
1400: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1401: and hoi.organization_id = g_organization_id

Line 1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)

1394: --and paei.aei_information13 = 'AP'
1395: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1396: and g_effective_date
1397: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1398: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1399: and hoi.org_information1 = paei.aei_information2
1400: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1401: and hoi.organization_id = g_organization_id
1402: -- irregular case for duplicate org