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

Line 240: FROM per_all_assignments_f asg,per_assignment_status_types past

236: SELECT soft_coding_keyflex_id FROM per_all_assignments_f
237: WHERE assignment_id = p_assignment_id AND
238: effective_start_date =
239: (SELECT max(effective_start_date)
240: FROM per_all_assignments_f asg,per_assignment_status_types past
241: WHERE past.per_system_status = 'ACTIVE_ASSIGN'
242: AND asg.assignment_status_type_id = past.assignment_status_type_id and assignment_id = p_assignment_id);
243:
244: CURSOR get_si_special_indicator(p_scl_id NUMBER) IS

Line 652: FROM per_assignment_status_types past, per_all_assignments_f asg

648: and p_Tax_Year_End_Date between pap.effective_start_date and pap.effective_end_date
649: and paa.effective_start_date =
650: (
651: SELECT MIN(asg.effective_start_date)
652: FROM per_assignment_status_types past, per_all_assignments_f asg
653: WHERE asg.assignment_id = paa.assignment_id
654: and past.per_system_status = 'ACTIVE_ASSIGN'
655: and asg.assignment_status_type_id = past.assignment_status_type_id
656: and asg.effective_start_date <= p_Tax_Year_End_Date