APPS.PER_GENERIC_REPORT_PKG dependencies on PER_VACANCIES

Line 87: per_vacancies c

83: cursor c1 is
84: select a.full_name, a.sex
85: from per_all_people_f a,
86: per_all_assignments_f b,
87: per_vacancies c
88: where a.business_group_id = b.business_group_id
89: and a.person_id = b.person_id
90: and trunc(sysdate)
91: between a.effective_start_date

Line 164: per_vacancies c

160: cursor c2 is
161: select a.full_name
162: from per_all_people_f a,
163: per_all_assignments_f b,
164: per_vacancies c
165: where a.business_group_id = b.business_group_id
166: and a.person_id = b.person_id
167: and trunc(sysdate)
168: between a.effective_start_date

Line 249: per_vacancies c

245: cursor c3 is
246: select a.full_name, a.sex
247: from per_all_people_f a,
248: per_all_assignments_f b,
249: per_vacancies c
250: where a.business_group_id = b.business_group_id
251: and a.person_id = b.person_id
252: and trunc(sysdate)
253: between a.effective_start_date

Line 471: l_vacancy_name per_vacancies.name%type;

467: --
468: -- Declare local variables
469: --
470: l_success boolean := FALSE;
471: l_vacancy_name per_vacancies.name%type;
472: l_report_number number;
473: --
474: -- The l_proc variable is used for handling errors that may occur during
475: -- program execution.

Line 485: from per_vacancies

481: -- case a cursor is used to check if a vacancy exists.
482: --
483: cursor c1 is
484: select name
485: from per_vacancies
486: where name = p_param_1;
487: begin
488: hr_utility.set_location('Entering:' || l_proc,5);
489: --