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

Line 924: per_all_assignments_f paa

920: BEGIN
921: select pgs.ceiling_step_id, nvl(paa.special_ceiling_step_id,pgs.ceiling_step_id)
922: into l_max_ceiling_step_id,l_special_ceiling_step_id
923: from per_grade_spines_f pgs,
924: per_all_assignments_f paa
925: where paa.assignment_id = p_assignment_id
926: and pgs.parent_spine_id = p_parent_spine_id
927: and pgs.grade_spine_id = p_grade_spine_id
928: and pgs.grade_id = paa.grade_id

Line 1476: FROM per_all_assignments_f asg,

1472: spp.object_version_number,
1473: spp.effective_start_date,
1474: spp.effective_end_date,
1475: pgs.grade_spine_id
1476: FROM per_all_assignments_f asg,
1477: per_grade_spines_f pgs,
1478: per_spinal_points psp1,
1479: per_spinal_point_steps_f sps1,
1480: per_spinal_points psp,

Line 1577: FROM per_all_assignments_f asg,

1573: spp.object_version_number,
1574: spp.effective_start_date,
1575: spp.effective_end_date,
1576: pgs.grade_spine_id
1577: FROM per_all_assignments_f asg,
1578: pay_people_groups ppg,
1579: per_grade_spines_f pgs,
1580: per_spinal_points psp1,
1581: per_spinal_point_steps_f sps1,

Line 1740: per_all_assignments_f paa,

1736: pos.adjusted_svc_date,
1737: paa.payroll_id
1738: from per_all_people_f pap,
1739: per_periods_of_service pos,
1740: per_all_assignments_f paa,
1741: per_spinal_point_placements_f spp
1742: where spp.assignment_id = paa.assignment_id
1743: and paa.person_id = pap.person_id
1744: and pos.person_id = pap.person_id