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

Line 162: from per_all_assignments_f

158: location_id,
159: special_ceiling_step_id,
160: last_update_date,
161: job_id
162: from per_all_assignments_f
163: where person_id = l_person_id
164: and effective_start_date = (select max(effective_start_date)
165: from per_all_assignments_f
166: where person_id = l_person_id

Line 165: from per_all_assignments_f

161: job_id
162: from per_all_assignments_f
163: where person_id = l_person_id
164: and effective_start_date = (select max(effective_start_date)
165: from per_all_assignments_f
166: where person_id = l_person_id
167: and assignment_type = 'E'
168: and primary_flag = 'Y')
169: and effective_end_date = (select max(effective_end_date)

Line 170: from per_all_assignments_f

166: where person_id = l_person_id
167: and assignment_type = 'E'
168: and primary_flag = 'Y')
169: and effective_end_date = (select max(effective_end_date)
170: from per_all_assignments_f
171: where person_id = l_person_id
172: and assignment_type = 'E'
173: and primary_flag = 'Y')
174: and assignment_type = 'E'

Line 714: from per_all_assignments_f

710: location_id,
711: special_ceiling_step_id,
712: last_update_date,
713: job_id
714: from per_all_assignments_f
715: where person_id = l_person_id
716: and effective_start_date = (select max(effective_start_date)
717: from per_all_assignments_f
718: where person_id = l_person_id

Line 717: from per_all_assignments_f

713: job_id
714: from per_all_assignments_f
715: where person_id = l_person_id
716: and effective_start_date = (select max(effective_start_date)
717: from per_all_assignments_f
718: where person_id = l_person_id
719: and assignment_type = 'E'
720: and primary_flag = 'Y')
721: and effective_end_date = (select max(effective_end_date)

Line 722: from per_all_assignments_f

718: where person_id = l_person_id
719: and assignment_type = 'E'
720: and primary_flag = 'Y')
721: and effective_end_date = (select max(effective_end_date)
722: from per_all_assignments_f
723: where person_id = l_person_id
724: and assignment_type = 'E'
725: and primary_flag = 'Y')
726: and assignment_type = 'E'