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

Line 233: ,per_assignment_status_types ast

229: SELECT asg.assignment_id
230: ,asg.object_version_number
231: ,asg.vacancy_id
232: FROM per_assignments_f asg
233: ,per_assignment_status_types ast
234: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
235: AND asg.person_id = c_person_id
236: AND asg.business_group_id = c_business_group_id
237: AND (c_assignment_id IS NULL OR

Line 254: ,per_assignment_status_types ast

250: SELECT asg.assignment_id
251: ,asg.object_version_number
252: ,asg.vacancy_id
253: FROM per_assignments_f asg
254: ,per_assignment_status_types ast
255: WHERE asg.assignment_status_type_id = ast.assignment_status_type_id
256: AND asg.person_id = c_person_id
257: AND asg.business_group_id = c_business_group_id
258: AND (c_assignment_id IS NULL OR

Line 272: FROM per_assignment_status_types

268: ) IS
269: SELECT assignment_status_type_id
270: ,active_flag
271: ,per_system_status
272: FROM per_assignment_status_types
273: WHERE per_system_status = 'ACCEPTED'
274: AND (business_group_id = c_business_group_id
275: OR legislation_code = c_leg_code
276: OR (legislation_code IS NULL