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 138: from per_assignments_f

134: select PAY_PROPOSAL_ID
135: from per_pay_proposals
136: where change_date = p_s_hire_date
137: and assignment_id = (select assignment_id
138: from per_assignments_f
139: where person_id = p_person_id
140: and primary_flag = 'Y'
141: and effective_start_date = p_hire_date
142: and assignment_type = 'E'

Line 730: from per_assignments_f

726: update per_pay_proposals
727: set change_date = p_hire_date
728: where change_date = p_s_hire_date
729: and assignment_id = (select assignment_id
730: from per_assignments_f
731: where person_id = p_person_id
732: and primary_flag = 'Y'
733: and effective_start_date = p_hire_date
734: and assignment_type = 'E'

Line 803: from per_assignments_f paf

799: --
800: cursor supervisor
801: is
802: select 'Y'
803: from per_assignments_f paf
804: where paf.assignment_type = 'E'
805: and paf.supervisor_id = p_person_id
806: and p_new_hire_date > paf.effective_start_date
807: and paf.effective_end_date >= p_old_hire_date;

Line 890: from per_assignments_f asg

886: --
887: cursor get_payroll
888: is
889: select asg.assignment_id
890: from per_assignments_f asg
891: where asg.person_id = p_person_id
892: and asg.payroll_id is not null;
893: begin
894: open get_payroll;