DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PER_ALL_PEOPLE_F

Line 403: from per_all_people_f ppf,

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

Line 420: from per_all_people_f ppf,

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