DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on PER_ALL_ASSIGNMENTS_F

Line 708: FROM per_all_assignments_f asg

704: , htt.stop_time
705: , htt.resource_id
706: , decode (greatest (asg.effective_start_date, htt.start_time), asg.effective_start_date
707: , 'M', 'R')
708: FROM per_all_assignments_f asg
709: , per_assignment_status_types past
710: , hxc_temp_tcd htt
711: WHERE asg.person_id = htt.resource_id
712: AND asg.effective_start_date > p_start_date

Line 727: , per_all_assignments_f paaf

723: , htt.stop_time
724: , min (paaf.effective_start_date) start_date
725: , max (paaf.effective_end_date) end_date
726: FROM hxc_temp_tcd htt
727: , per_all_assignments_f paaf
728: , per_assignment_status_types past
729: WHERE paaf.person_id = htt.resource_id
730: AND paaf.effective_start_date <= p_end_date
731: AND paaf.effective_end_date >= p_start_date