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

Line 105: , per_assignment_status_types past

101: asg.EFFECTIVE_START_DATE,
102: asg.EFFECTIVE_END_DATE
103: FROM
104: per_assignments_f asg
105: , per_assignment_status_types past
106: WHERE asg.supervisor_id = :3
107: AND asg.assignment_type IN ( ''E'' , ''C'' )
108: AND asg.primary_flag = ''Y''
109: AND trunc(asg.effective_start_date) <= :4

Line 129: , per_assignment_status_types past

125: perasn.EFFECTIVE_START_DATE,
126: perasn.EFFECTIVE_END_DATE
127: FROM
128: per_assignments_f perasn
129: , per_assignment_status_types past
130: WHERE perasn.person_id <> :3
131: AND perasn.primary_flag = ''Y''
132: AND assignment_type IN (''E'' , ''C'' )
133: START WITH person_id = :4

Line 709: , per_assignment_status_types past

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
713: AND asg.effective_end_date < p_end_date

Line 728: , per_assignment_status_types past

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
732: AND past.assignment_status_type_id = paaf.assignment_status_type_id