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.HR_PROCESS_ASSIGNMENT_SS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2366: per_assignment_status_types past

2362:
2363: cursor last_change_date is
2364: select max(asf.effective_start_date)
2365: from per_all_assignments_f asf,
2366: per_assignment_status_types past
2367: where asf.assignment_id=l_assignment_id
2368: and asf.ASSIGNMENT_STATUS_TYPE_ID = past.ASSIGNMENT_STATUS_TYPE_ID;
2369: -- ns 10-May-03: Since termination is handled on the effective date page
2370: -- and update insert may be allowed even if future dated termination,

Line 2378: per_assignment_status_types past

2374: -- New cursor to see if any assignment record exist for the selected date
2375: cursor correction_date is
2376: select null
2377: from per_all_assignments_f asf,
2378: per_assignment_status_types past
2379: where asf.assignment_id = l_assignment_id
2380: and asf.assignment_status_type_id = past.assignment_status_type_id
2381: and asf.effective_start_date = l_effective_date;
2382:

Line 6359: from per_assignment_status_types

6355: and jwc.state_code = hl.region_2;
6356: --
6357: cursor status_type is
6358: select per_system_status
6359: from per_assignment_status_types
6360: where assignment_status_type_id=p_assignment_status_type_id;
6361: --
6362:
6363: cursor csr_pgp_segments is