DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PER_ALL_WORKFORCE_V

Line 397: -- For contingent workers there is a join to per_all_workforce_v

393: is
394:
395: --
396: -- Check the person is valid for the entire absence term.
397: -- For contingent workers there is a join to per_all_workforce_v
398: -- so that contingent workers are only included when the profile
399: -- option HR_TREAT_CWK_AS_EMP is Yes.
400: --
401: cursor c_per_valid_for_absence is

Line 422: per_all_workforce_v pawv

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
425: and ppf.person_id = pawv.person_id
426: and ppf.current_npw_flag = 'Y'