APPS.HR_APPROVAL_WF dependencies on PER_VACANCIES

Line 40: FROM per_vacancies pv

36: --
37: -- returns vacancy info
38: CURSOR g_csr_vacancies(p_vacancy_id in number) IS
39: SELECT recruiter_id,job_id
40: FROM per_vacancies pv
41: WHERE pv.vacancy_id = p_vacancy_id;
42:
43: --
44: g_vacancies g_csr_vacancies%rowtype;

Line 638: l_vacancy_id per_vacancies.vacancy_id%type;

634: -- -------------------------------------------------------------------------
635: l_proc_name varchar2(61) := g_package||'set_routing_details3';
636: l_creator_person_id per_people_f.person_id%type;
637: l_approval_routing_id per_people_f.person_id%type;
638: l_vacancy_id per_vacancies.vacancy_id%type;
639: --
640: begin
641: --
642: if ( funmode = 'RUN' ) then

Line 1103: l_vacancy_id per_vacancies.vacancy_id%type;

1099: -- local variables
1100: -- -------------------------------------------------------------------------
1101: l_proc_name varchar2(61) := g_package||'set_URL7';
1102: l_url varchar2(2000);
1103: l_vacancy_id per_vacancies.vacancy_id%type;
1104: l_job_id per_vacancies.job_id%type;
1105: --
1106: begin
1107: --

Line 1104: l_job_id per_vacancies.job_id%type;

1100: -- -------------------------------------------------------------------------
1101: l_proc_name varchar2(61) := g_package||'set_URL7';
1102: l_url varchar2(2000);
1103: l_vacancy_id per_vacancies.vacancy_id%type;
1104: l_job_id per_vacancies.job_id%type;
1105: --
1106: begin
1107: --
1108: if ( funmode = 'RUN' ) then

Line 1171: l_person_id per_vacancies.vacancy_id%type;

1167: -- -------------------------------------------------------------------------
1168: l_proc_name varchar2(61) := g_package||'set_URL8';
1169: l_url varchar2(2000);
1170: l_email_address per_people_f.email_address%type;
1171: l_person_id per_vacancies.vacancy_id%type;
1172: --
1173: begin
1174: --
1175: if ( funmode = 'RUN' ) then