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

Line 1270: FROM per_assignment_status_types past

1266:
1267: --Check if the assignment is terminated or ended
1268: SELECT max (paaf.effective_start_date)
1269: INTO l_asg_end_date
1270: FROM per_assignment_status_types past
1271: ,per_all_assignments_f paaf
1272: WHERE paaf.assignment_id = l_assignment_id
1273: AND paaf.assignment_status_type_id = past.assignment_status_type_id
1274: AND past.per_system_status IN ('TERM_ASSIGN','END');

Line 2869: from per_assignment_status_types past,

2865: select nvl(min(paaf.effective_start_date), fnd_date.canonical_to_date('1001/01/01 00:00:00'))
2866: , nvl(max(paaf.effective_end_date), fnd_date.canonical_to_date('4712/12/31 00:00:00'))
2867: into l_asg_hire_date
2868: , l_asg_term_date
2869: from per_assignment_status_types past,
2870: per_all_assignments_f paaf
2871: where paaf.assignment_id = l_assignment_id
2872: and paaf.effective_start_date <= l_tax_year_end_date
2873: and paaf.assignment_status_type_id = past.assignment_status_type_id