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 272: per_assignment_status_types ast

268: AND asg.person_id = per.person_id
269: AND asg.effective_start_date =
270: (SELECT MIN (asg2.effective_start_date)
271: FROM per_assignments_f asg2,
272: per_assignment_status_types ast
273: WHERE asg2.assignment_id = asg.assignment_id
274: AND asg2.effective_start_date <= p_end_date
275: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
276: AND asg2.assignment_type = 'E'

Line 7753: FROM per_assignment_status_types ast

7749: AND paf.assignment_type = 'E'
7750: AND paf.assignment_status_type_id =
7751: --Added for bug fix 3828506
7752: (SELECT ast.assignment_status_type_id
7753: FROM per_assignment_status_types ast
7754: WHERE ast.per_system_status = 'ACTIVE_ASSIGN'
7755: AND ast.assignment_status_type_id = paf.assignment_status_type_id)
7756: AND paa.assignment_id = paf.assignment_id
7757: AND paa.action_status IN ('C','S') --10225372

Line 7819: per_assignment_status_types ast --Bug fix 3828506

7815: AND asg.person_id = per.person_id
7816: AND asg.effective_start_date =
7817: (SELECT MIN (asg2.effective_start_date)
7818: FROM per_assignments_f asg2,
7819: per_assignment_status_types ast --Bug fix 3828506
7820: WHERE asg2.assignment_id = asg.assignment_id
7821: AND asg2.effective_start_date <= p_end_date
7822: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
7823: --Added for bug fix 3828506

Line 7932: FROM per_assignment_status_types ast

7928: --AND asg.primary_flag = 'Y' -- removed join
7929: AND asg.assignment_type = 'E'
7930: AND asg.assignment_status_type_id =
7931: ( SELECT ast.assignment_status_type_id
7932: FROM per_assignment_status_types ast
7933: WHERE ast.per_system_status ='ACTIVE_ASSIGN'
7934: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
7935: AND asg.effective_start_date =
7936: (SELECT MIN (asg2.effective_start_date)

Line 7938: per_assignment_status_types ast --For bug fix 3828506

7934: AND ast.assignment_status_type_id = asg.assignment_status_type_id)
7935: AND asg.effective_start_date =
7936: (SELECT MIN (asg2.effective_start_date)
7937: FROM per_assignments_f asg2,
7938: per_assignment_status_types ast --For bug fix 3828506
7939: WHERE asg2.assignment_id = asg.assignment_id
7940: AND asg2.effective_start_date <= p_end_date
7941: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
7942: --Added for bug fix 3828506

Line 8045: per_assignment_status_types ast --Bug fix 3828506

8041: AND asg.person_id = per.person_id
8042: AND asg.effective_start_date =
8043: (SELECT MIN (asg2.effective_start_date)
8044: FROM per_assignments_f asg2,
8045: per_assignment_status_types ast --Bug fix 3828506
8046: WHERE asg2.assignment_id = asg.assignment_id
8047: AND asg2.effective_start_date <= p_end_date
8048: AND NVL (asg2.effective_end_date, p_end_date) >= p_start_date
8049: AND asg2.assignment_type = 'E'