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.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1875: from per_periods_of_service p

1871: l_ret_val BOOLEAN;
1872:
1873: cursor c2 is
1874: select 'x'
1875: from per_periods_of_service p
1876: where ((trunc(p.actual_termination_date) < p_date
1877: and p.actual_termination_date is not null)
1878: or (trunc(p.projected_termination_date) < p_date
1879: and p.projected_termination_date is not null))

Line 2615: from per_periods_of_service

2611: --
2612: cursor c21b is
2613: select greatest(date_start),
2614: actual_termination_date
2615: from per_periods_of_service
2616: where person_id = p_per_id
2617: and date_start <= p_sess;
2618: --
2619: begin

Line 2697: from per_periods_of_service pos

2693: l_ret_val BOOLEAN;
2694: --
2695: cursor chk_periods is
2696: select 1
2697: from per_periods_of_service pos
2698: where pos.person_id = p_per_id
2699: and pos.date_start > p_curr_date_end
2700: and p_proj_start between
2701: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);