APPS.HRI_OPL_SUP_STATUS_HST dependencies on PER_ALL_ASSIGNMENTS_F

Line 270: FROM per_all_assignments_f

266: SELECT supervisor_id,
267: effective_start_date,
268: effective_end_date,
269: assignment_status_type_id
270: FROM per_all_assignments_f
271: WHERE assignment_type in ('E','C')
272: AND primary_flag = 'Y'
273: ) asg,
274: per_assignment_status_types ast,

Line 495: FROM per_all_assignments_f

491: SELECT supervisor_id,
492: effective_start_date,
493: effective_end_date,
494: assignment_status_type_id
495: FROM per_all_assignments_f
496: WHERE assignment_type in ('E','C')
497: AND primary_flag = 'Y'
498: ) asg,
499: per_assignment_status_types ast,

Line 746: FROM per_all_assignments_f

742: SELECT supervisor_id,
743: effective_start_date,
744: effective_end_date,
745: assignment_status_type_id
746: FROM per_all_assignments_f
747: WHERE assignment_type in ('E','C')
748: ) asg,
749: per_assignment_status_types ast,
750: (select person_id,

Line 942: FROM per_all_assignments_f

938: SELECT supervisor_id,
939: effective_start_date,
940: effective_end_date,
941: assignment_status_type_id
942: FROM per_all_assignments_f
943: WHERE assignment_type in ('E','C')
944: ) asg,
945: per_assignment_status_types ast,
946: --

Line 1056: FROM per_all_assignments_f asg

1052: dbg('Inside update_event_queue');
1053: --
1054: UPDATE hri_eq_sprvsr_hstry_chgs eq
1055: SET person_id = (SELECT person_id
1056: FROM per_all_assignments_f asg
1057: WHERE eq.assignment_id=asg.assignment_id
1058: AND rownum=1
1059: );
1060: --

Line 1144: ,per_all_assignments_f asg

1140: ,eq.erlst_evnt_effective_date
1141: ,'DERIVED'
1142: FROM
1143: hri_eq_sprvsr_hstry_chgs eq
1144: ,per_all_assignments_f asg
1145: WHERE eq.assignment_id = asg.assignment_id
1146: AND asg.effective_start_date >= eq.erlst_evnt_effective_date
1147: AND eq.source_code IS NULL
1148: AND NOT EXISTS