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

Line 198: from per_all_assignments_f paf,

194: select paf.assignment_id
195: ,paf.job_id
196: ,paf.effective_start_date
197: ,paf.assignment_type
198: from per_all_assignments_f paf,
199: per_assignment_status_types past
200: where paf.organization_id = P_ORGANIZATION_ID_CHILD
201: and P_EFFECTIVE_DATE between paf.effective_start_date
202: and paf.effective_end_date

Line 236: from per_all_assignments_f paf,

232: select paf.assignment_id
233: ,paf.job_id
234: ,paf.effective_start_date
235: ,paf.assignment_type
236: from per_all_assignments_f paf,
237: per_assignment_status_types past
238: where paf.organization_id = p_organization_id_child
239: and paf.effective_start_date <= P_DATE_FROM
240: and paf.assignment_status_type_id = past.assignment_status_type_id

Line 242: from per_all_assignments_f paf1

238: where paf.organization_id = p_organization_id_child
239: and paf.effective_start_date <= P_DATE_FROM
240: and paf.assignment_status_type_id = past.assignment_status_type_id
241: and P_DATE_TO <= (select max(paf1.effective_end_date)
242: from per_all_assignments_f paf1
243: ,per_assignment_status_types past1
244: where paf.assignment_id = paf1.assignment_id
245: and paf1.assignment_status_type_id = past1.assignment_status_type_id
246: and past.per_system_status = past1.per_system_status)

Line 277: ,per_all_assignments_f paf

273: )
274: is
275: select paf.job_id
276: from per_periods_of_service pos
277: ,per_all_assignments_f paf
278: where pos.date_start <= P_DATE_FROM
279: and pos.actual_termination_date is not null
280: and pos.actual_termination_date between P_DATE_FROM and P_DATE_TO
281: and pos.period_of_service_id = paf.period_of_service_id

Line 287: from per_all_assignments_f paf1

283: and paf.primary_flag = 'Y'
284: and paf.organization_id = P_ORGANIZATION_ID_CHILD
285: and paf.effective_start_date in
286: (select max(paf1.effective_start_date)
287: from per_all_assignments_f paf1
288: where paf1.assignment_id = paf.assignment_id
289: and paf1.effective_end_date
290: between P_DATE_FROM
291: and P_DATE_TO)

Line 295: ,per_all_assignments_f paf

291: and P_DATE_TO)
292: UNION
293: select paf.job_id
294: from per_periods_of_placement pop
295: ,per_all_assignments_f paf
296: where pop.date_start <= P_DATE_FROM
297: and pop.actual_termination_date is not null
298: and pop.actual_termination_date between P_DATE_FROM
299: and P_DATE_TO

Line 307: from per_all_assignments_f paf1

303: and paf.primary_flag = 'Y'
304: and paf.organization_id = P_ORGANIZATION_ID_CHILD
305: and paf.effective_start_date in
306: (select max(paf1.effective_start_date)
307: from per_all_assignments_f paf1
308: where paf1.assignment_id = paf.assignment_id
309: and paf1.effective_end_date
310: between P_DATE_FROM
311: and P_DATE_TO);