DBA Data[Home] [Help]

APPS.PER_ABS_BUS dependencies on PER_ALL_WORKFORCE_V

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

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

Line 423: per_all_workforce_v pawv

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