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.HR_JP_DATA_MIGRATION_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 456: from per_all_assignments_f pa,

452: INDEX(PA PER_ASSIGNMENTS_F_PK) */
453: pbg.business_group_id bg_id,
454: pbg.name bg_name,
455: pa.assignment_number ass_num
456: from per_all_assignments_f pa,
457: per_business_groups_perf pbg
458: where pa.assignment_id = p_assignment_id
459: and p_effective_date
460: between pa.effective_start_date and pa.effective_end_date

Line 1354: per_all_assignments_f pa

1350: pbg.name bg_name,
1351: pa.assignment_id,
1352: pa.assignment_number
1353: from per_business_groups_perf pbg,
1354: per_all_assignments_f pa
1355: where pbg.legislation_code = g_legislation_code
1356: --and pbg.business_group_id = 3101
1357: --and pa.assignment_number
1358: -- between 1000 and 1200

Line 1363: from per_all_assignments_f pa2

1359: and pa.business_group_id = pbg.business_group_id
1360: and pa.effective_start_date = (
1361: select /*+ INDEX(PA2 PER_ASSIGNMENTS_F_PK) */
1362: max(pa2.effective_start_date)
1363: from per_all_assignments_f pa2
1364: where pa2.assignment_id = pa.assignment_id);
1365: --
1366: l_csr_range_ass csr_range_ass%rowtype;
1367: --