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 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 380: ,per_assignment_status_types past

376: ,paf.job_id
377: ,paf.effective_start_date
378: ,paf.assignment_type
379: from per_all_assignments_f paf
380: ,per_assignment_status_types past
381: where paf.organization_id = P_ORGANIZATION_ID_CHILD
382: and P_EFFECTIVE_DATE between paf.effective_start_date
383: and paf.effective_end_date
384: and paf.assignment_status_type_id = past.assignment_status_type_id

Line 427: ,per_assignment_status_types past

423: ,paf.effective_end_date
424: --bug 6124652 ends here
425: ,paf.assignment_type
426: from per_all_assignments_f paf
427: ,per_assignment_status_types past
428: where paf.organization_id = P_ORGANIZATION_ID_CHILD
429: --bug 6124652 starts here
430: -- and P_EFFECTIVE_DATE between paf.effective_start_date
431: -- and paf.effective_end_date

Line 478: ,per_assignment_status_types past

474: ,paf.job_id
475: ,paf.effective_start_date
476: ,paf.assignment_type
477: from per_all_assignments_f paf
478: ,per_assignment_status_types past
479: where paf.organization_id = P_ORGANIZATION_ID_CHILD
480: --Bug 6124652 starts here
481: -- and paf.effective_start_date <= P_DATE_FROM
482: and P_DATE_FROM between paf.effective_start_date

Line 488: ,per_assignment_status_types past1

484: --Bug 6124652 ends here
485: and paf.assignment_status_type_id = past.assignment_status_type_id
486: and P_DATE_TO <= (select max(paf1.effective_end_date)
487: from per_all_assignments_f paf1
488: ,per_assignment_status_types past1
489: where paf.assignment_id = paf1.assignment_id
490: and paf1.assignment_status_type_id = past1.assignment_status_type_id
491: and past.per_system_status = past1.per_system_status)
492: and (

Line 525: ,per_assignment_status_types past

521: select paf.assignment_id
522: ,paf.job_id
523: ,paf.effective_start_date
524: from per_all_assignments_f paf
525: ,per_assignment_status_types past
526: where paf.organization_id = p_organization_id_child
527: -- and paf.business_group_id = P_BUSINESS_GROUP_ID
528: and paf.assignment_type = 'A'
529: and paf.effective_start_date between P_DATE_FROM and P_DATE_TO

Line 544: per_assignment_status_types past

540: select paf.assignment_id
541: ,paf.job_id
542: ,paf.effective_start_date
543: from per_all_assignments_f paf,
544: per_assignment_status_types past
545: where paf.organization_id = p_organization_id_child
546: -- and paf.business_group_id = P_BUSINESS_GROUP_ID
547: and paf.assignment_type = 'A'
548: and paf.effective_start_date between P_DATE_FROM and P_DATE_TO