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

Line 308: per_assignment_status_types status,

304: cursor get_active_assignment
305: is
306: select asgn.assignment_id
307: from per_all_assignments_f asgn, /* from per_assignments_f per Commented for bug 2983491 , Added per_all_assignments_f for it*/
308: per_assignment_status_types status,
309: (select person_id, actual_termination_date from per_periods_of_service
310: union all
311: select person_id, actual_termination_date
312: from per_periods_of_placement) po

Line 2132: per_assignment_status_types past

2128: prd.resource_effective_start_date,
2129: prd.resource_effective_end_date
2130: FROM pa_resources_denorm prd,
2131: per_all_assignments_f paf,
2132: per_assignment_status_types past
2133: WHERE prd.person_id = paf.person_id
2134: AND prd.person_id = p_person_id
2135: AND paf.assignment_status_type_id = past.assignment_status_type_id
2136: AND paf.primary_flag = 'Y'