APPS.PER_US_EEO4_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 549: FROM hr_all_organization_units

545: WHERE ppp.assignment_id = pro.assignment_id
546: AND pro.change_date <= TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'')
547: AND pro.approved = ''Y'' )
548: AND ass.organization_id IN (SELECT organization_id
549: FROM hr_all_organization_units
550: WHERE business_group_id = ' || p_business_group_id || '
551: AND TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'') BETWEEN date_from AND NVL(date_to,TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'')) )
552: AND ass.assignment_status_type_id = past.assignment_status_type_id
553: AND peo.current_employee_flag = ''Y''

Line 612: FROM hr_all_organization_units

608: WHERE ppp.assignment_id = pro.assignment_id
609: AND pro.change_date <= ''' || to_char(l_report_date) || '''
610: AND pro.approved = ''Y'' )
611: AND ass.organization_id IN (SELECT organization_id
612: FROM hr_all_organization_units
613: WHERE business_group_id = ' || p_business_group_id || '
614: AND SYSDATE BETWEEN date_from AND NVL(date_to,SYSDATE) )
615: AND ass.assignment_status_type_id = past.assignment_status_type_id
616: AND peo.current_employee_flag = ''Y''

Line 1039: FROM hr_all_organization_units hou,

1035: ||' '||NVL(hl.address_line_3,' ') address,
1036: NVL(hl.town_or_city,' ') town_or_city,
1037: NVL(hl.region_1,' ') county,
1038: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
1039: FROM hr_all_organization_units hou,
1040: hr_locations hl
1041: WHERE hou.location_id = hl.location_id
1042: AND hou.business_group_id = g_business_group_id
1043: AND hou.organization_id = g_business_group_id;

Line 1053: FROM hr_all_organization_units

1049: ||' '||NVL(address_line_3,' ') address,
1050: NVL(town_or_city,' ') town_or_city,
1051: NVL(region_1,' ') county,
1052: NVL(region_2,' ')||' '||NVL(postal_code,' ') state_zip
1053: FROM hr_all_organization_units
1054: WHERE business_group_id = g_business_group_id
1055: and organization_id = g_business_group_id;
1056: */
1057: