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

Line 1250: per_assignment_status_types past

1246:
1247: cursor csr_asg_term is
1248: select max(asg.effective_end_date) asg_end_date
1249: from per_all_assignments_f asg,
1250: per_assignment_status_types past
1251: where asg.assignment_id = p_assignment_id
1252: and past.per_system_status = 'ACTIVE_ASSIGN'
1253: and asg.assignment_status_type_id = past.assignment_status_type_id
1254: and asg.effective_start_date <= p_rep_date

Line 1317: FROM per_assignment_status_types past, per_all_assignments_f asg

1313: and p_reporting_end_Date between pap.effective_start_date and pap.effective_end_date
1314: and paa.effective_start_date =
1315: (
1316: SELECT MIN(asg.effective_start_date)
1317: FROM per_assignment_status_types past, per_all_assignments_f asg
1318: WHERE asg.assignment_id = paa.assignment_id
1319: and past.per_system_status = 'ACTIVE_ASSIGN'
1320: and asg.assignment_status_type_id = past.assignment_status_type_id
1321: and asg.effective_start_date <= p_reporting_End_Date