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.PER_PEOPLE4_PKG dependencies on PER_ASSIGNMENTS_F

Line 142: from per_assignments_f

138: select PAY_PROPOSAL_ID
139: from per_pay_proposals
140: where change_date = p_s_hire_date
141: and assignment_id = (select assignment_id
142: from per_assignments_f
143: where person_id = p_person_id
144: and primary_flag = 'Y'
145: and effective_start_date = p_hire_date
146: and assignment_type = 'E'

Line 818: from per_assignments_f

814: update per_pay_proposals
815: set change_date = p_hire_date
816: where change_date = p_s_hire_date
817: and assignment_id = (select assignment_id
818: from per_assignments_f
819: where person_id = p_person_id
820: and primary_flag = 'Y'
821: and effective_start_date = p_hire_date
822: and assignment_type = 'E'

Line 907: from per_assignments_f paf

903: --
904: cursor supervisor
905: is
906: select 'Y'
907: from per_assignments_f paf
908: where paf.assignment_type = 'E'
909: and paf.supervisor_id = p_person_id
910: and p_new_hire_date > paf.effective_start_date
911: and paf.effective_end_date >= p_old_hire_date;

Line 1014: from per_assignments_f asg

1010: --
1011: cursor get_payroll
1012: is
1013: select asg.assignment_id
1014: from per_assignments_f asg
1015: where asg.person_id = p_person_id
1016: and asg.payroll_id is not null;
1017: begin
1018: open get_payroll;