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

Line 222: per_assignment_status_types past

218: select min(aaf.assignment_id) assignment_id
219: from per_all_assignments_f aaf,
220: hr_soft_coding_keyflex hsck,
221: pay_all_payrolls_f papf,
222: per_assignment_status_types past
223: where aaf.person_id = p_person_id
224: AND p_effective_date between
225: aaf.effective_start_date and aaf.effective_end_date
226: AND hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id

Line 237: per_assignment_status_types past2

233: AND hsck.segment1 in ( SELECT distinct(hsck.segment1)
234: FROM hr_soft_coding_keyflex hsck2,
235: pay_all_payrolls_f papf2,
236: per_all_assignments_f paaf,
237: per_assignment_status_types past2
238: WHERE hsck2.soft_coding_keyflex_id = papf2.soft_coding_keyflex_id
239: AND papf2.payroll_id =paaf.payroll_id
240: AND past2.assignment_status_type_id = paaf.assignment_status_type_id
241: AND paaf.person_id = p_person_id