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 1193: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))

1189: and paei.information_type = 'JP_ASS_LIG_INFO'
1190: -- include PC for customized valuset
1191: --and paei.aei_information1 in ('GIP','LINC')
1192: and g_effective_date
1193: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1194: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1195: and hoi.org_information1 = paei.aei_information2
1196: and hoi.org_information_context
1197: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

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

1190: -- include PC for customized valuset
1191: --and paei.aei_information1 in ('GIP','LINC')
1192: and g_effective_date
1193: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1194: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1195: and hoi.org_information1 = paei.aei_information2
1196: and hoi.org_information_context
1197: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')
1198: and hoi.organization_id = g_organization_id

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

1239: and paei.information_type = 'JP_ASS_LIP_INFO'
1240: -- include PC for customized valuset
1241: --and paei.aei_information1 in ('GIP','LINC')
1242: and g_effective_date
1243: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1244: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1245: and hoi.org_information1 = paei.aei_information2
1246: and hoi.org_information_context
1247: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')

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

1240: -- include PC for customized valuset
1241: --and paei.aei_information1 in ('GIP','LINC')
1242: and g_effective_date
1243: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1244: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1245: and hoi.org_information1 = paei.aei_information2
1246: and hoi.org_information_context
1247: = decode(paei.aei_information1,'GIP','JP_LI_GIP_INFO','LINC','JP_LI_LINC_INFO','X')
1248: and hoi.organization_id = g_organization_id

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

1291: -- include PC for customized valuset
1292: --and paei.aei_information13 = 'AP'
1293: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1294: and g_effective_date
1295: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1296: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1297: and hoi.org_information1 = paei.aei_information2
1298: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1299: and hoi.organization_id = g_organization_id

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

1292: --and paei.aei_information13 = 'AP'
1293: and paei.aei_information1 <> decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1','EQ','S')
1294: and g_effective_date
1295: between nvl(fnd_date.canonical_to_date(paei.aei_information3),nvl(fnd_date.canonical_to_date(paei.aei_information4)+1,hr_api.g_sot))
1296: and nvl(fnd_date.canonical_to_date(paei.aei_information4),hr_api.g_eot)
1297: and hoi.org_information1 = paei.aei_information2
1298: and hoi.org_information_context = 'JP_ACCIDENT_INS_INFO'
1299: and hoi.organization_id = g_organization_id
1300: -- irregular case for duplicate org