APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_VACANCIES

Line 783: ||' FROM per_vacancies pv, per_requisitions pr'

779: ||')';
780: ELSIF p_search_type = g_vacancy_type THEN --vacancy
781: l_dynamic_sql := 'SELECT pv.vacancy_id'
782: ||',pv.name || '' (''||pr.name||'')'' name'
783: ||' FROM per_vacancies pv, per_requisitions pr'
784: ||' WHERE pv.vacancy_id IN ('
785: ||p_ids
786: ||')'
787: ||' AND pv.requisition_id = pr.requisition_id';

Line 1112: ||' ,per_vacancies pv'

1108: ||',pv.name || '' (''||pr.name||'')'' name'
1109: ||' FROM per_assignments_f paf'
1110: ||' ,per_people_f ppf'
1111: ||' ,per_person_type_usages_f ptu'
1112: ||' ,per_vacancies pv'
1113: ||' ,per_requisitions pr'
1114: ||' WHERE paf.business_group_id = '
1115: ||l_business_group
1116: ||' AND paf.assignment_type = '||l_assignment_type

Line 1266: ||' FROM per_vacancies pv, per_requisitions pr'

1262: END IF;
1263: ELSIF p_search_type = g_vacancy_type THEN
1264: l_dynamic_sql := 'SELECT pv.vacancy_id'
1265: ||',pv.name || '' (''||pr.name||'')'' name'
1266: ||' FROM per_vacancies pv, per_requisitions pr'
1267: ||' WHERE pv.business_group_id = '
1268: ||l_business_group
1269: ||' AND TRUNC(sysdate) BETWEEN pv.date_from AND'
1270: ||' NVL(pv.date_to, TRUNC(sysdate))'

Line 1376: FROM per_vacancies pv,

1372: CURSOR csr_vac_info IS
1373: SELECT pv.name || ' (' || pr.name ||')'
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

Line 1483: FROM per_vacancies

1479: ,organization_id
1480: ,job_id
1481: ,position_id
1482: ,grade_id
1483: FROM per_vacancies
1484: WHERE vacancy_id = p_vacancy_id;
1485:
1486: l_vacancy_rec csr_vacancy%rowtype;
1487:

Line 2676: per_vacancies pv,

2672: SELECT pasf.vacancy_id
2673: ,pv.name ||' ('||pr.name||')' name
2674: FROM per_assignments_f pasf,
2675: per_assignment_status_types past,
2676: per_vacancies pv,
2677: per_requisitions pr
2678: WHERE pasf.person_id = p_person_id
2679: AND p_effective_date BETWEEN pasf.effective_start_date
2680: AND pasf.effective_end_date

Line 2892: per_vacancies pv,

2888: ,pasf.vacancy_id
2889: ,pv.name||' ('||pr.name||')' name
2890: FROM per_assignments_f pasf,
2891: per_assignment_status_types past,
2892: per_vacancies pv,
2893: per_requisitions pr
2894: WHERE pasf.person_id = p_person_id
2895: AND p_effective_date BETWEEN pasf.effective_start_date
2896: AND pasf.effective_end_date