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

Line 1016: per_assignment_status_types past

1012: --
1013: cursor csr_active_home_asgs(p_person_id number) is
1014: select paaf.assignment_id, paaf.object_version_number
1015: from per_all_assignments_f paaf,
1016: per_assignment_status_types past
1017: where paaf.person_id = p_person_id
1018: and l_dpl_rec.start_date between
1019: paaf.effective_start_date and paaf.effective_end_date
1020: and paaf.assignment_type = 'E'

Line 2174: per_assignment_status_types past

2170: --
2171: cursor csr_susp_home_asgs(p_person_deployment_id number) is
2172: select paaf.assignment_id, paaf.effective_start_date
2173: from per_all_assignments_f paaf,
2174: per_assignment_status_types past
2175: where paaf.person_id = L_DPL_REC.FROM_PERSON_ID
2176: and paaf.effective_start_date = L_DPL_REC.START_DATE
2177: and paaf.assignment_status_type_id = past.assignment_status_type_id
2178: and past.per_system_status = 'SUSP_ASSIGN';

Line 2515: per_assignment_status_types past

2511: --
2512: cursor csr_susp_home_asgs(p_person_id number) is
2513: select paaf.assignment_id, paaf.object_version_number
2514: from per_all_assignments_f paaf,
2515: per_assignment_status_types past
2516: where paaf.person_id = p_person_id
2517: and L_END_DATE_IN between
2518: paaf.effective_start_date and paaf.effective_end_date
2519: and paaf.assignment_type = 'E'

Line 2525: per_assignment_status_types past1

2521: and past.per_system_status = 'SUSP_ASSIGN'
2522: and exists
2523: (select 1
2524: from per_all_assignments_f paaf1,
2525: per_assignment_status_types past1
2526: where paaf1.assignment_id = paaf.assignment_id
2527: and paaf1.effective_start_date = L_DPL_REC.START_DATE
2528: and paaf1.assignment_status_type_id = past1.assignment_status_type_id
2529: and past1.per_system_status = 'SUSP_ASSIGN')

Line 2533: per_assignment_status_types past2

2529: and past1.per_system_status = 'SUSP_ASSIGN')
2530: and exists
2531: (select 1
2532: from per_all_assignments_f paaf2,
2533: per_assignment_status_types past2
2534: where paaf2.assignment_id = paaf.assignment_id
2535: and paaf2.effective_end_date = L_DPL_REC.START_DATE-1
2536: and paaf2.assignment_status_type_id = past2.assignment_status_type_id
2537: and past2.per_system_status = 'ACTIVE_ASSIGN');