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 PER_ASSIGNMENT_EXTRA_INFO

Line 1224: from per_assignment_extra_info paei,

1220: paei.aei_information7 contractor_name,
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

Line 1280: from per_assignment_extra_info paei,

1276: paei.aei_information7 contractor_name,
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

Line 1336: from per_assignment_extra_info paei,

1332: paei.aei_information8 contractor_name,
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

Line 1389: from per_assignment_extra_info paei,

1385: paei.aei_information8 beneficiary_name,
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