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

Line 2657: FROM per_assignment_status_types ast

2653: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2654: AND scl.segment4 = to_char(g_paye_ref)
2655: AND paaf.assignment_status_type_id in
2656: (SELECT ast.assignment_status_type_id
2657: FROM per_assignment_status_types ast
2658: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2659: )
2660: AND paaf.effective_end_date between g_archive_start_date and g_archive_end_date;
2661:

Line 2670: FROM per_assignment_status_types ast

2666: FROM per_all_assignments_f paaf
2667: WHERE paaf.assignment_id = p_assignment_id
2668: AND paaf.assignment_status_type_id in
2669: (SELECT ast.assignment_status_type_id
2670: FROM per_assignment_status_types ast
2671: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2672: );
2673:
2674:

Line 2840: FROM per_assignment_status_types ast

2836: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2837: AND scl.segment4 = to_char(g_paye_ref)
2838: AND paaf.assignment_status_type_id in
2839: (SELECT ast.assignment_status_type_id
2840: FROM per_assignment_status_types ast
2841: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2842: )
2843: AND paaf.effective_end_date between g_archive_start_date and g_archive_end_date;
2844:

Line 2853: FROM per_assignment_status_types ast

2849: FROM per_all_assignments_f paaf
2850: WHERE paaf.assignment_id = p_assignment_id
2851: AND paaf.assignment_status_type_id in
2852: (SELECT ast.assignment_status_type_id
2853: FROM per_assignment_status_types ast
2854: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
2855: );
2856:
2857: -- Bug 2943335 used balance name as a parameter

Line 3659: FROM per_assignment_status_types ast

3655: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
3656: same per_system_status (5073577) */
3657: and paf1.assignment_status_type_id in
3658: (SELECT ast.assignment_status_type_id
3659: FROM per_assignment_status_types ast
3660: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3661: )
3662: )
3663: AND as1.effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')

Line 3680: FROM per_assignment_status_types ast

3676: from per_all_assignments_f paf1
3677: where paf1.assignment_id = a.assignment_id
3678: and paf1.assignment_status_type_id in
3679: (SELECT ast.assignment_status_type_id
3680: FROM per_assignment_status_types ast
3681: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3682: )
3683: )
3684: )

Line 3744: FROM per_assignment_status_types ast

3740: /* changed the cursor to handle case where 2 user defined assignment status exist mapping to
3741: same per_system_status (5073577) */
3742: AND paf.assignment_status_type_id in
3743: (SELECT ast.assignment_status_type_id
3744: FROM per_assignment_status_types ast
3745: WHERE ast.per_system_status in ('ACTIVE_ASSIGN','SUSP_ASSIGN')
3746: )
3747: AND g_archive_end_date between papf.effective_start_date and papf.effective_end_date
3748: AND papf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id