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_ASSIGNMENT_STATUS_TYPES

Line 199: per_assignment_status_types past

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
203: and paf.assignment_status_type_id = past.assignment_status_type_id

Line 237: per_assignment_status_types past

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
241: and P_DATE_TO <= (select max(paf1.effective_end_date)

Line 243: ,per_assignment_status_types past1

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)
247: and (