DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PER_ALL_PEOPLE_F

Line 404: from per_all_people_f ppf,

400: -- option HR_TREAT_CWK_AS_EMP is Yes.
401: --
402: cursor c_per_valid_for_absence is
403: select null
404: from per_all_people_f ppf,
405: per_periods_of_service pos
406: where ppf.person_id = p_person_id
407: and ppf.person_id = pos.person_id
408: and ppf.current_employee_flag = 'Y'

Line 421: from per_all_people_f ppf,

417: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
418: and (p_date_end is null or p_date_end
419: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
420: union select null
421: from per_all_people_f ppf,
422: per_periods_of_placement pop,
423: per_all_workforce_v pawv
424: where ppf.person_id = p_person_id
425: and ppf.person_id = pop.person_id