APPS.HR_HRHD_INITIAL_LOAD dependencies on PER_JOBS

Line 264: p_job_id per_jobs.job_id%type;

260: ,p_number_of_files in Number)
261: IS
262:
263:
264: p_job_id per_jobs.job_id%type;
265: p_business_grp_id per_jobs.business_group_id%type;
266: p_eff_date varchar2(10);
267: p_lang_code varchar2(10);
268: p_eff_status varchar2(10);

Line 265: p_business_grp_id per_jobs.business_group_id%type;

261: IS
262:
263:
264: p_job_id per_jobs.job_id%type;
265: p_business_grp_id per_jobs.business_group_id%type;
266: p_eff_date varchar2(10);
267: p_lang_code varchar2(10);
268: p_eff_status varchar2(10);
269: p_job_descr per_jobs_tl.name%type;

Line 269: p_job_descr per_jobs_tl.name%type;

265: p_business_grp_id per_jobs.business_group_id%type;
266: p_eff_date varchar2(10);
267: p_lang_code varchar2(10);
268: p_eff_status varchar2(10);
269: p_job_descr per_jobs_tl.name%type;
270:
271: l_record_counter Number :=0;
272: l_file_counter Number :=0;
273: r Number :=1;

Line 291: from per_jobs pj,per_jobs_tl tl

287: tl.language,
288: tl.name,
289: to_char(DATE_FROM,'YYYY-MM-DD') ,
290: 'A'
291: from per_jobs pj,per_jobs_tl tl
292: where pj.job_id = tl.job_id
293: and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
294: union
295: select pj.job_id,

Line 301: from per_jobs pj,per_jobs_tl tl

297: tl.language,
298: tl.name,
299: to_char(DATE_TO,'YYYY-MM-DD') ,
300: 'I'
301: from per_jobs pj,per_jobs_tl tl
302: where pj.job_id = tl.job_id
303: and date_to is not null
304: order by business_group_id,job_id;
305: