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

Line 68: per_assignment_status_types past

64: SELECT COUNT(hsck.segment1) Num, hsck.segment1 tax_district
65: FROM hr_soft_coding_keyflex hsck,
66: pay_all_payrolls_f papf,
67: per_all_assignments_f paaf,
68: per_assignment_status_types past
69: WHERE hsck.soft_coding_keyflex_id = papf.soft_coding_keyflex_id
70: AND papf.payroll_id =paaf.payroll_id
71: AND past.assignment_status_type_id = paaf.assignment_status_type_id
72: AND paaf.person_id = p_person_id

Line 145: per_assignment_status_types past

141: and exists ( SELECT 1
142: FROM per_all_assignments_f paaf,
143: pay_all_payrolls_f papf,
144: hr_soft_coding_keyflex hsck,
145: per_assignment_status_types past
146: WHERE paaf.person_id = p_person_id
147: and paaf.assignment_id not in (paa.assignment_id)
148: and paaf.effective_start_date <= p_end_date
149: and paaf.effective_end_date >= p_start_date