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

Line 2306: from per_assignment_status_types

2302: (g_start_date between effective_start_date and effective_end_date or
2303: g_end_date between effective_start_date and effective_end_date or
2304: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and
2305: assignment_status_type_id in (select assignment_status_type_id
2306: from per_assignment_status_types
2307: where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') );
2308:
2309: l_start_date date;
2310: l_end_date date;

Line 3442: from per_assignment_status_types

3438: (g_start_date between effective_start_date and effective_end_date or
3439: g_end_date between effective_start_date and effective_end_date or
3440: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and
3441: assignment_status_type_id in (select assignment_status_type_id
3442: from per_assignment_status_types
3443: where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') )
3444: ORDER BY effective_start_date;
3445:
3446: l_start_date date;

Line 8732: per_assignment_status_types past

8728:
8729: CURSOR non_active_asg_csr IS
8730: SELECT count(*)
8731: FROM per_assignments_f paf,
8732: per_assignment_status_types past
8733: WHERE assignment_id = x_assignment_id
8734: AND g_start_date <= effective_end_date
8735: AND g_end_date >= effective_start_date
8736: AND past.assignment_status_type_id = paf.assignment_status_type_id