DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on PER_VACANCIES

Line 77: ,vacancy per_vacancies.name%type default null

73: ,organization hr_all_organization_units.name%type default null
74: ,organization_id per_all_assignments_f.organization_id%type default null
75: ,people_group pay_people_groups.group_name%type default null
76: ,people_group_id per_all_assignments_f.people_group_id%type default null
77: ,vacancy per_vacancies.name%type default null
78: ,vacancy_id per_all_assignments_f.vacancy_id%type default null
79: ,requisition per_requisitions.name%type default null
80: ,requisition_id per_requisitions.requisition_id%type default null
81: ,salary_basis per_pay_bases.name%type default null

Line 306: from per_vacancies vac

302: cursor csr_vacancy
303: (p_vacancy_id number) is
304: select vac.name
305: , rec.name
306: from per_vacancies vac
307: , per_requisitions rec
308: where vac.vacancy_id=p_vacancy_id
309: and vac.requisition_id=rec.requisition_id;
310: --

Line 2519: ,vacancy in per_vacancies.name%type default null

2515: ,organization in hr_all_organization_units.name%type default null
2516: ,organization_id in per_all_assignments_f.organization_id%type default null
2517: ,people_group in pay_people_groups.group_name%type default null
2518: ,people_group_id in per_all_assignments_f.people_group_id%type default null
2519: ,vacancy in per_vacancies.name%type default null
2520: ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
2521: ,requisition in per_requisitions.name%type default null
2522: ,requisition_id in per_requisitions.requisition_id%type default null
2523: ,salary_basis in per_pay_bases.name%type default null