APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on HR_ORGANIZATION_UNITS

Line 744: ||' FROM hr_organization_units'

740: ||p_ids
741: ||')';
742: ELSIF p_search_type = g_organization_type THEN --org
743: l_dynamic_sql := 'SELECT organization_id, name'
744: ||' FROM hr_organization_units'
745: ||' WHERE organization_id IN ('
746: ||p_ids
747: ||')';
748: ELSIF p_search_type = g_job_type THEN --job

Line 989: ||' ,hr_organization_units hou'

985: ||' ,hou.name name'
986: ||' FROM per_assignments_f paf'
987: ||' ,per_people_f ppf'
988: ||' ,per_person_type_usages_f ptu'
989: ||' ,hr_organization_units hou'
990: ||' WHERE paf.business_group_id = '
991: ||l_business_group
992: ||' AND paf.assignment_type = '||l_assignment_type
993: ||' AND ppf.person_id = ptu.person_id '

Line 1209: ||' FROM hr_organization_units hou,'

1205: ||' WHERE UPPER(location_code) '
1206: || l_filter_clause;
1207: ELSIF p_search_type = g_organization_type THEN
1208: l_dynamic_sql := 'SELECT distinct(hou.organization_id), hou.name'
1209: ||' FROM hr_organization_units hou,'
1210: ||' hr_organization_information hoi'
1211: ||' WHERE hou.business_group_id = '
1212: ||l_business_group
1213: ||' AND TRUNC(sysdate) BETWEEN hou.date_from AND'

Line 1356: FROM hr_organization_units hou,

1352: ,p_location_code out nocopy varchar2) IS
1353:
1354: CURSOR csr_org_info IS
1355: SELECT hou.name, hl.location_code
1356: FROM hr_organization_units hou,
1357: hr_locations_all hl
1358: WHERE hou.organization_id = p_id
1359: AND hou.location_id = hl.location_id(+);
1360:

Line 1364: hr_organization_units hou,

1360:
1361: CURSOR csr_pos_info IS
1362: SELECT hou.name, hl.location_code
1363: FROM hr_positions_f pp,
1364: hr_organization_units hou,
1365: hr_locations_all hl
1366: WHERE pp.position_id = p_id
1367: AND TRUNC(SYSDATE) BETWEEN pp.effective_start_date
1368: AND pp.effective_end_date

Line 1378: hr_organization_units hou,

1374: ,hou.name
1375: ,hl.location_code
1376: FROM per_vacancies pv,
1377: per_requisitions pr,
1378: hr_organization_units hou,
1379: hr_locations_all hl
1380: WHERE pv.vacancy_id = p_id
1381: AND pv.requisition_id = pr.requisition_id
1382: AND pv.organization_id = hou.organization_id(+)

Line 1575: l_business_group_id hr_organization_units.business_group_id%type;

1571: AND rtx1.language(+) = userenv('LANG')
1572: AND rtx2.language(+) = userenv('LANG')
1573: ORDER BY cpl.name;
1574:
1575: l_business_group_id hr_organization_units.business_group_id%type;
1576:
1577: l_core_competence_table g_competence_table;
1578: l_core_count number;
1579: l_core_e_count number;

Line 1970: l_org_id hr_organization_units.organization_id%TYPE;

1966: ,p_competence_count out nocopy number
1967: ,p_essential_count out nocopy number
1968: ,p_desirable_count out nocopy number) IS
1969:
1970: l_org_id hr_organization_units.organization_id%TYPE;
1971: l_job_id per_jobs.job_id%TYPE;
1972:
1973: l_core_competence_table g_competence_table;
1974: l_core_count number;

Line 2849: hr_organization_units hou

2845: CURSOR csr_deployment_by_person IS
2846: SELECT pasf.assignment_id, pasf.organization_id, hou.name
2847: FROM per_assignments_f pasf,
2848: per_assignment_status_types past,
2849: hr_organization_units hou
2850: WHERE pasf.person_id = p_person_id
2851: AND p_effective_date BETWEEN pasf.effective_start_date
2852: AND pasf.effective_end_date
2853: AND pasf.organization_id = hou.organization_id