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 2380: from per_assignment_status_types

2376: (g_start_date between effective_start_date and effective_end_date or
2377: g_end_date between effective_start_date and effective_end_date or
2378: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and
2379: assignment_status_type_id in (select assignment_status_type_id
2380: from per_assignment_status_types
2381: where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') );
2382:
2383: l_start_date date;
2384: l_end_date date;

Line 3516: from per_assignment_status_types

3512: (g_start_date between effective_start_date and effective_end_date or
3513: g_end_date between effective_start_date and effective_end_date or
3514: (g_start_date <= effective_start_date and g_end_date >= effective_end_date )) and
3515: assignment_status_type_id in (select assignment_status_type_id
3516: from per_assignment_status_types
3517: where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') )
3518: ORDER BY effective_start_date;
3519:
3520: l_start_date date;

Line 8806: per_assignment_status_types past

8802:
8803: CURSOR non_active_asg_csr IS
8804: SELECT count(*)
8805: FROM per_assignments_f paf,
8806: per_assignment_status_types past
8807: WHERE assignment_id = x_assignment_id
8808: AND g_start_date <= effective_end_date
8809: AND g_end_date >= effective_start_date
8810: AND past.assignment_status_type_id = paf.assignment_status_type_id