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_ORGANIZATION_INFORMATION

Line 82: hr_organization_information hoi

78: select /*+ ORDERED */
79: nvl(nvl(pp.prl_information1, hoi.org_information2),'CTR_EE')
80: from /* Payroll and Business Group details */
81: pay_all_payrolls_f pp,
82: hr_organization_information hoi
83: where pp.payroll_id = g_payroll_id
84: and g_effective_date
85: between pp.effective_start_date and pp.effective_end_date
86: and hoi.organization_id(+) = pp.business_group_id

Line 198: hr_organization_information hoi1,

194: hoi2.org_information1 tax_office_name,
195: hoi1.org_information1 salary_payer_name,
196: hoi1.org_information6||hoi1.org_information7||hoi1.org_information8 salary_payer_address
197: from hr_all_organization_units hou,
198: hr_organization_information hoi1,
199: hr_organization_information hoi2
200: where hou.organization_id = g_organization_id
201: and hoi1.organization_id(+) = hou.organization_id
202: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'

Line 199: hr_organization_information hoi2

195: hoi1.org_information1 salary_payer_name,
196: hoi1.org_information6||hoi1.org_information7||hoi1.org_information8 salary_payer_address
197: from hr_all_organization_units hou,
198: hr_organization_information hoi1,
199: hr_organization_information hoi2
200: where hou.organization_id = g_organization_id
201: and hoi1.organization_id(+) = hou.organization_id
202: and hoi1.org_information_context(+) = 'JP_TAX_SWOT_INFO'
203: and hoi2.organization_id(+) = hou.organization_id

Line 1225: hr_organization_information hoi

1221: paei.aei_information8 beneficiary_name,
1222: paei.aei_information9 beneficiary_relship,
1223: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1224: from per_assignment_extra_info paei,
1225: hr_organization_information hoi
1226: where paei.assignment_id = p_assignment_id
1227: and paei.information_type = 'JP_ASS_LIG_INFO'
1228: -- include PC for customized valuset
1229: --and paei.aei_information1 in ('GIP','LINC')

Line 1241: from hr_organization_information hoi2

1237: and hoi.organization_id = g_organization_id
1238: -- irregular case for duplicate org
1239: and not exists(
1240: select null
1241: from hr_organization_information hoi2
1242: where hoi2.org_information1 = hoi.org_information1
1243: and hoi2.org_information_context = hoi.org_information_context
1244: and hoi2.organization_id = hoi.organization_id
1245: and nvl(hoi2.ORG_INFORMATION10,'O') = nvl(hoi.ORG_INFORMATION10,'O')

Line 1281: hr_organization_information hoi

1277: paei.aei_information8 beneficiary_name,
1278: paei.aei_information9 beneficiary_relship,
1279: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1280: from per_assignment_extra_info paei,
1281: hr_organization_information hoi
1282: where paei.assignment_id = p_assignment_id
1283: and paei.information_type = 'JP_ASS_CMI_INFO'
1284: -- include PC for customized valuset
1285: --and paei.aei_information1 in ('GIP','LINC')

Line 1297: from hr_organization_information hoi2

1293: and hoi.organization_id = g_organization_id
1294: -- irregular case for duplicate org
1295: and not exists(
1296: select null
1297: from hr_organization_information hoi2
1298: where hoi2.org_information1 = hoi.org_information1
1299: and hoi2.org_information_context = hoi.org_information_context
1300: and hoi2.organization_id = hoi.organization_id
1301: and nvl(hoi2.ORG_INFORMATION10,'N') = nvl(hoi.ORG_INFORMATION10,'N')

Line 1337: hr_organization_information hoi

1333: paei.aei_information9 beneficiary_name,
1334: paei.aei_information10 beneficiary_relship,
1335: fnd_number.canonical_to_number(paei.aei_information11) linc_prem
1336: from per_assignment_extra_info paei,
1337: hr_organization_information hoi
1338: where paei.assignment_id = p_assignment_id
1339: and paei.information_type = 'JP_ASS_LIP_INFO'
1340: -- include PC for customized valuset
1341: --and paei.aei_information1 in ('GIP','LINC')

Line 1353: from hr_organization_information hoi2

1349: and hoi.organization_id = g_organization_id
1350: -- irregular case for duplicate org
1351: and not exists(
1352: select null
1353: from hr_organization_information hoi2
1354: where hoi2.org_information1 = hoi.org_information1
1355: and hoi2.org_information_context = hoi.org_information_context
1356: and hoi2.organization_id = hoi.organization_id
1357: and nvl(hoi2.ORG_INFORMATION10,'O') = nvl(hoi.ORG_INFORMATION10,'O')

Line 1390: hr_organization_information hoi

1386: paei.aei_information9 beneficiary_relship,
1387: decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1',paei.aei_information10,null) maturity_repayment,
1388: fnd_number.canonical_to_number(paei.aei_information11) annual_prem
1389: from per_assignment_extra_info paei,
1390: hr_organization_information hoi
1391: where paei.assignment_id = p_assignment_id
1392: and paei.information_type = 'JP_ASS_AI_INFO'
1393: -- include PC for customized valuset
1394: --and paei.aei_information13 = 'AP'

Line 1405: from hr_organization_information hoi2

1401: and hoi.organization_id = g_organization_id
1402: -- irregular case for duplicate org
1403: and not exists(
1404: select null
1405: from hr_organization_information hoi2
1406: where hoi2.org_information1 = hoi.org_information1
1407: and hoi2.org_information_context = hoi.org_information_context
1408: and hoi2.organization_id = hoi.organization_id
1409: and hoi2.org_information_id < hoi.org_information_id)