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_NZ_HOLIDAYS dependencies on PER_ASSIGNMENTS_F

Line 1175: per_assignments_f asg

1171: ,c_calculation_date DATE
1172: ,c_assignment_id NUMBER) IS
1173: SELECT TO_DATE(scl.segment2,'YYYY/MM/DD HH24:MI:SS')
1174: FROM hr_soft_coding_keyflex scl,
1175: per_assignments_f asg
1176: WHERE asg.assignment_id = c_assignment_id
1177: AND asg.business_group_id + 0 = c_business_group_id
1178: AND scl.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1179: AND scl.enabled_flag = 'Y'

Line 1679: from per_assignments_f paaf

1675: select 1
1676: from per_absence_attendances paa,
1677: per_absence_attendance_types paat
1678: where paa.person_id = (select distinct person_id
1679: from per_assignments_f paaf
1680: where paaf.assignment_id = c_assignment_id)
1681: and paa.business_group_id = c_business_group_id
1682: and paa.business_group_id = paat.business_group_id
1683: and paa.absence_attendance_type_id = paat.absence_attendance_type_id

Line 2697: from per_assignments_f a

2693: select a.effective_start_date
2694: , a.effective_end_date
2695: , a.normal_hours
2696: , a.frequency
2697: from per_assignments_f a
2698: where a.assignment_id = p_assignment_id
2699: and a.effective_start_date <= p_end_date
2700: and a.effective_end_date >= p_start_date
2701: order by

Line 3016: from per_assignments_f a

3012: select a.effective_start_date
3013: , a.effective_end_date
3014: , a.normal_hours
3015: , a.frequency
3016: from per_assignments_f a
3017: where a.assignment_id = p_assignment_id
3018: and a.effective_start_date <= p_end_date
3019: and a.effective_end_date >= p_start_date
3020: order by