APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 282: per_periods_of_service ppos

278: select trunc(ppos.actual_termination_date) term_date,
279: trunc(ppos.projected_termination_date) end_dt
280: from
281: per_all_people_f ppf,
282: per_periods_of_service ppos
283: where person_type_exists(ppf.person_type_id) is not null and
284: ppos.actual_termination_date between
285: ppf.effective_start_date and
286: ppf.effective_end_date and

Line 304: per_periods_of_service ppos

300: trunc(ppos.projected_termination_date) end_dt
301: from
302: per_all_people_f ppf,
303: per_all_assignments_f paf,
304: per_periods_of_service ppos
305: where person_type_exists(ppf.person_type_id) is not null and
306: paf.person_id = ppf.person_id and
307: ppos.actual_termination_date between
308: ppf.effective_start_date and

Line 334: per_periods_of_service ppos

330: trunc(ppos.projected_termination_date) end_dt
331: from
332: per_all_people_f ppf,
333: per_all_assignments_f paf,
334: per_periods_of_service ppos
335: where person_type_exists(ppf.person_type_id) is not null and
336: paf.person_id = ppf.person_id and
337: ppf.business_group_id=p_business_group_id and
338: ppf.person_id = p_person_id and