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

Line 292: ,per_assignment_status_types ast

288: select asg.assignment_id
289: ,asg.object_version_number
290: ,asg.vacancy_id
291: from per_all_assignments_f asg
292: ,per_assignment_status_types ast
293: where asg.assignment_status_type_id = ast.assignment_status_type_id
294: and asg.person_id = c_person_id
295: and asg.business_group_id = c_business_group_id
296: and (c_assignment_id is null or

Line 314: ,per_assignment_status_types ast

310: select asg.assignment_id
311: ,asg.object_version_number
312: ,asg.vacancy_id
313: from per_all_assignments_f asg
314: ,per_assignment_status_types ast
315: where asg.assignment_status_type_id = ast.assignment_status_type_id
316: and asg.person_id = c_person_id
317: and asg.business_group_id = c_business_group_id
318: and (c_assignment_id is null or

Line 333: from per_assignment_status_types

329: ) is
330: select assignment_status_type_id
331: ,active_flag
332: ,per_system_status
333: from per_assignment_status_types
334: where per_system_status = 'ACCEPTED'
335: and (business_group_id = c_business_group_id
336: or legislation_code = c_leg_code
337: or (legislation_code is null