APPS.HR_HRHD_INITIAL_LOAD dependencies on PER_JOBS

Line 183: p_job_id per_jobs.job_id%type;

179: ,retcode OUT NOCOPY VARCHAR2)
180: IS
181:
182:
183: p_job_id per_jobs.job_id%type;
184: p_business_grp_id per_jobs.business_group_id%type;
185: p_eff_date varchar2(10);
186: p_lang_code varchar2(10);
187: p_eff_status varchar2(10);

Line 184: p_business_grp_id per_jobs.business_group_id%type;

180: IS
181:
182:
183: p_job_id per_jobs.job_id%type;
184: p_business_grp_id per_jobs.business_group_id%type;
185: p_eff_date varchar2(10);
186: p_lang_code varchar2(10);
187: p_eff_status varchar2(10);
188: p_job_descr per_jobs_tl.name%type;

Line 188: p_job_descr per_jobs_tl.name%type;

184: p_business_grp_id per_jobs.business_group_id%type;
185: p_eff_date varchar2(10);
186: p_lang_code varchar2(10);
187: p_eff_status varchar2(10);
188: p_job_descr per_jobs_tl.name%type;
189:
190: /*Cursor to fetch the job details*/
191:
192: cursor csr_job_initial_load is

Line 199: from per_jobs pj,per_jobs_tl tl

195: tl.language,
196: tl.name,
197: to_char(DATE_FROM,'YYYY-MM-DD') ,
198: 'A'
199: from per_jobs pj,per_jobs_tl tl
200: where pj.job_id = tl.job_id
201: and nvl(date_to,to_date('31/12/4712','DD/MM/YYYY')) > sysdate
202: union
203: select pj.job_id,

Line 209: from per_jobs pj,per_jobs_tl tl

205: tl.language,
206: tl.name,
207: to_char(DATE_TO,'YYYY-MM-DD') ,
208: 'I'
209: from per_jobs pj,per_jobs_tl tl
210: where pj.job_id = tl.job_id
211: and date_to is not null
212: order by business_group_id,job_id;
213: