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 926: per_all_assignments_f paa

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

Line 1478: FROM per_all_assignments_f asg,

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

Line 1584: FROM per_all_assignments_f asg,

1580: spp.object_version_number,
1581: spp.effective_start_date,
1582: spp.effective_end_date,
1583: pgs.grade_spine_id
1584: FROM per_all_assignments_f asg,
1585: pay_people_groups ppg,
1586: per_grade_spines_f pgs,
1587: per_spinal_points psp1,
1588: per_spinal_point_steps_f sps1,

Line 1747: per_all_assignments_f paa,

1743: pos.adjusted_svc_date,
1744: paa.payroll_id
1745: from per_all_people_f pap,
1746: per_periods_of_service pos,
1747: per_all_assignments_f paa,
1748: per_spinal_point_placements_f spp
1749: where spp.assignment_id = paa.assignment_id
1750: and paa.person_id = pap.person_id
1751: and pos.person_id = pap.person_id