APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 1979: from per_periods_of_service p

1975: l_ret_val BOOLEAN;
1976:
1977: cursor c2 is
1978: select 'x'
1979: from per_periods_of_service p
1980: where ((trunc(p.actual_termination_date) < p_date
1981: and p.actual_termination_date is not null)
1982: or (trunc(p.projected_termination_date) < p_date
1983: and p.projected_termination_date is not null))

Line 2720: from per_periods_of_service

2716: --
2717: cursor c21b is
2718: select greatest(date_start),
2719: actual_termination_date
2720: from per_periods_of_service
2721: where person_id = p_per_id
2722: and date_start <= p_sess;
2723: --
2724: begin

Line 2802: from per_periods_of_service pos

2798: l_ret_val BOOLEAN;
2799: --
2800: cursor chk_periods is
2801: select 1
2802: from per_periods_of_service pos
2803: where pos.person_id = p_per_id
2804: and pos.date_start > p_curr_date_end
2805: and p_proj_start between
2806: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);

Line 2995: from per_periods_of_service

2991: and mat.leave_type in ('AA','AB');
2992: --
2993: cursor period_of_service(l_person_id varchar2, continous_emp_date date) is
2994: select 1
2995: from per_periods_of_service
2996: where person_id = l_person_id
2997: /* Bug Fix 13486124, included Adjusted service date in the check
2998: and date_start <= continous_emp_date
2999: */