APPS.PER_US_EEO4_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 483: FROM hr_all_organization_units

479: WHERE ppp.assignment_id = pro.assignment_id
480: AND pro.change_date <= ''' || to_char(l_report_date) || '''
481: AND pro.approved = ''Y'' )
482: AND ass.organization_id IN (SELECT organization_id
483: FROM hr_all_organization_units
484: WHERE business_group_id = ' || p_business_group_id || '
485: AND SYSDATE BETWEEN date_from AND NVL(date_to,SYSDATE) )
486: AND ass.assignment_status_type_id = past.assignment_status_type_id
487: AND peo.current_employee_flag = ''Y''

Line 530: FROM hr_all_organization_units

526: WHERE ppp.assignment_id = pro.assignment_id
527: AND pro.change_date <= ''' || to_char(l_report_date) || '''
528: AND pro.approved = ''Y'' )
529: AND ass.organization_id IN (SELECT organization_id
530: FROM hr_all_organization_units
531: WHERE business_group_id = ' || p_business_group_id || '
532: AND SYSDATE BETWEEN date_from AND NVL(date_to,SYSDATE) )
533: AND ass.assignment_status_type_id = past.assignment_status_type_id
534: AND peo.current_employee_flag = ''Y''

Line 909: FROM hr_all_organization_units hou,

905: ||' '||NVL(hl.address_line_3,' ') address,
906: NVL(hl.town_or_city,' ') town_or_city,
907: NVL(hl.region_1,' ') county,
908: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
909: FROM hr_all_organization_units hou,
910: hr_locations hl
911: WHERE hou.location_id = hl.location_id
912: AND hou.business_group_id = g_business_group_id
913: AND hou.organization_id = g_business_group_id;

Line 923: FROM hr_all_organization_units

919: ||' '||NVL(address_line_3,' ') address,
920: NVL(town_or_city,' ') town_or_city,
921: NVL(region_1,' ') county,
922: NVL(region_2,' ')||' '||NVL(postal_code,' ') state_zip
923: FROM hr_all_organization_units
924: WHERE business_group_id = g_business_group_id
925: and organization_id = g_business_group_id;
926: */
927: