APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_REQUISITIONS

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 1113: ||' ,per_requisitions pr'

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
1117: ||' AND ppf.person_id = ptu.person_id '

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 1377: per_requisitions pr,

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
1381: AND pv.requisition_id = pr.requisition_id

Line 2677: per_requisitions pr

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
2681: AND pasf.vacancy_id = pv.vacancy_id

Line 2893: per_requisitions pr

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
2897: AND pasf.vacancy_id = pv.vacancy_id