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

Line 265: per_assignment_status_types ast

261: AND asg.person_id = per.person_id
262: AND asg.effective_start_date =
263: (SELECT MIN (asg2.effective_start_date)
264: FROM per_assignments_f asg2,
265: per_assignment_status_types ast
266: WHERE asg2.assignment_id = asg.assignment_id
267: AND asg2.effective_start_date <= p_end_date
268: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
269: AND asg2.assignment_type = 'E'

Line 4689: FROM per_assignment_status_types ast

4685: AND paf.assignment_type = 'E'
4686: AND paf.assignment_status_type_id =
4687: --Added for bug fix 3828506
4688: (SELECT ast.assignment_status_type_id
4689: FROM per_assignment_status_types ast
4690: WHERE ast.per_system_status = 'ACTIVE_ASSIGN'
4691: AND ast.assignment_status_type_id = paf.assignment_status_type_id)
4692: AND paa.assignment_id = paf.assignment_id
4693: AND paa.action_status = 'C'

Line 4754: per_assignment_status_types ast --Bug fix 3828506

4750: AND asg.person_id = per.person_id
4751: AND asg.effective_start_date =
4752: (SELECT MIN (asg2.effective_start_date)
4753: FROM per_assignments_f asg2,
4754: per_assignment_status_types ast --Bug fix 3828506
4755: WHERE asg2.assignment_id = asg.assignment_id
4756: AND asg2.effective_start_date <= p_end_date
4757: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
4758: --Added for bug fix 3828506

Line 4865: FROM per_assignment_status_types ast

4861: --AND asg.primary_flag = 'Y' -- removed join
4862: AND asg.assignment_type = 'E'
4863: AND asg.assignment_status_type_id =
4864: ( SELECT ast.assignment_status_type_id
4865: FROM per_assignment_status_types ast
4866: WHERE ast.per_system_status ='ACTIVE_ASSIGN'
4867: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
4868: AND asg.effective_start_date =
4869: (SELECT MIN (asg2.effective_start_date)

Line 4871: per_assignment_status_types ast --For bug fix 3828506

4867: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
4868: AND asg.effective_start_date =
4869: (SELECT MIN (asg2.effective_start_date)
4870: FROM per_assignments_f asg2,
4871: per_assignment_status_types ast --For bug fix 3828506
4872: WHERE asg2.assignment_id = asg.assignment_id
4873: AND asg2.effective_start_date <= p_end_date
4874: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
4875: --Added for bug fix 3828506