DBA Data[Home] [Help]

APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 259: per_periods_of_service ppos

255: select trunc(ppos.actual_termination_date) term_date,
256: trunc(ppos.projected_termination_date) end_dt
257: from
258: per_all_people_f ppf,
259: per_periods_of_service ppos
260: where person_type_exists(ppf.person_type_id) is not null and
261: ppos.actual_termination_date between
262: ppf.effective_start_date and
263: ppf.effective_end_date and

Line 281: per_periods_of_service ppos

277: trunc(ppos.projected_termination_date) end_dt
278: from
279: per_all_people_f ppf,
280: per_all_assignments_f paf,
281: per_periods_of_service ppos
282: where person_type_exists(ppf.person_type_id) is not null and
283: paf.person_id = ppf.person_id and
284: ppos.actual_termination_date between
285: ppf.effective_start_date and