DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 408: ,hr_all_organization_units_tl orgTl

404: ,per_all_positions pps
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

Line 496: ,hr_all_organization_units_tl orgTl

492: ,per_all_positions pps
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