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 1186: from per_assignment_extra_info paei,

1182: paei.aei_information7 contractor_name,
1183: paei.aei_information8 beneficiary_name,
1184: paei.aei_information9 beneficiary_relship,
1185: fnd_number.canonical_to_number(paei.aei_information10) linc_prem
1186: from per_assignment_extra_info paei,
1187: hr_organization_information hoi
1188: where paei.assignment_id = p_assignment_id
1189: and paei.information_type = 'JP_ASS_LIG_INFO'
1190: -- include PC for customized valuset

Line 1236: from per_assignment_extra_info paei,

1232: paei.aei_information8 contractor_name,
1233: paei.aei_information9 beneficiary_name,
1234: paei.aei_information10 beneficiary_relship,
1235: fnd_number.canonical_to_number(paei.aei_information11) linc_prem
1236: from per_assignment_extra_info paei,
1237: hr_organization_information hoi
1238: where paei.assignment_id = p_assignment_id
1239: and paei.information_type = 'JP_ASS_LIP_INFO'
1240: -- include PC for customized valuset

Line 1287: from per_assignment_extra_info paei,

1283: paei.aei_information8 beneficiary_name,
1284: paei.aei_information9 beneficiary_relship,
1285: decode(to_char(sign(g_effective_date - c_st_upd_date_2007)),'-1',paei.aei_information10,null) maturity_repayment,
1286: fnd_number.canonical_to_number(paei.aei_information11) annual_prem
1287: from per_assignment_extra_info paei,
1288: hr_organization_information hoi
1289: where paei.assignment_id = p_assignment_id
1290: and paei.information_type = 'JP_ASS_AI_INFO'
1291: -- include PC for customized valuset