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 2368: per_assignment_status_types past

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

Line 2380: per_assignment_status_types past

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

Line 6689: from per_assignment_status_types

6685: and jwc.state_code = hl.region_2;
6686: --
6687: cursor status_type is
6688: select per_system_status
6689: from per_assignment_status_types
6690: where assignment_status_type_id=p_assignment_status_type_id;
6691: --
6692:
6693: cursor csr_pgp_segments is