APPS.PER_US_EEO4A_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 887: FROM hr_all_organization_units hou,

883: ||' '||NVL(hl.address_line_3,' ') address,
884: NVL(hl.town_or_city,' ') town_or_city,
885: NVL(hl.region_1,' ') county,
886: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
887: FROM hr_all_organization_units hou,
888: hr_locations hl
889: WHERE hou.location_id = hl.location_id
890: AND hou.business_group_id = g_business_group_id
891: AND hou.organization_id = g_business_group_id;

Line 1577: FROM hr_all_organization_units

1573: WHERE ppp.assignment_id = pro.assignment_id
1574: AND pro.change_date <= TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'')
1575: AND pro.approved = ''Y'' )
1576: AND ass.organization_id IN (SELECT organization_id
1577: FROM hr_all_organization_units
1578: WHERE business_group_id = ' || p_business_group_id || '
1579: AND TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'') BETWEEN date_from AND NVL(date_to,TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'')) )
1580: AND ass.assignment_status_type_id = past.assignment_status_type_id
1581: AND peo.current_employee_flag = ''Y''