DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_BUSINESS_GROUPS

Line 409: ,per_business_groups pbg

405: ,per_person_type_usages_f ptu
406: ,per_person_types pts
407: ,per_person_types_tl ptt
408: ,hr_all_organization_units_tl orgTl
409: ,per_business_groups pbg
410: WHERE ppf.person_id = paf.person_id
411: AND (pts.system_person_type IN ('EMP','CWK') OR (paf.assignment_type = 'A' AND pts.system_person_type ='APL'))
412: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
413: AND ( (nvl(fnd_profile.value('OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS'),'N') = 'Y'

Line 497: ,per_business_groups pbg

493: ,per_person_type_usages_f ptu
494: ,per_person_types pts
495: ,per_person_types_tl ptt
496: ,hr_all_organization_units_tl orgTl
497: ,per_business_groups pbg
498: WHERE ppf.person_id = paf.person_id
499: AND (pts.system_person_type IN (''EMP'',''CWK'') OR (paf.assignment_type = ''A'' AND pts.system_person_type =''APL''))
500: AND trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
501: AND ( (nvl(fnd_profile.value(''OTA_ALLOW_FUTURE_ENDDATED_EMP_ENROLLMENTS''),''N'') = ''Y''