DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 101: ,hr_all_organization_units org

97: ,per_all_people_f p2
98: ,per_all_assignments_f asg2
99: -- ,per_addresses ad
100: ,hr_locations loc
101: ,hr_all_organization_units org
102: WHERE pp.person_id = p_person_id
103: AND trunc(sysdate) BETWEEN pp.effective_start_date AND pp.effective_end_date
104: and asg.person_id = pp.person_id
105: AND asg.primary_flag = 'Y'