APPS.GHR_RIF_PKG dependencies on PER_JOBS

Line 251: cursor job_name(p_job_id per_jobs.job_id%TYPE)

247: rif.agency_code_subelement
248: from ghr_rif_criteria rif
249: where rif.rif_criteria_id = p_rif_criteria_id;
250:
251: cursor job_name(p_job_id per_jobs.job_id%TYPE)
252: is
253: select jobs.name
254: from per_jobs jobs
255: where jobs.job_id = p_job_id;

Line 254: from per_jobs jobs

250:
251: cursor job_name(p_job_id per_jobs.job_id%TYPE)
252: is
253: select jobs.name
254: from per_jobs jobs
255: where jobs.job_id = p_job_id;
256:
257: cursor position_name(p_position_id hr_positions_f.position_id%TYPE,p_effective_date date )
258: is

Line 503: -- Job name - select from per_jobs - in job_id,business_group_id

499: p_lookup_code => l_rif_reg.occ_code,
500: p_lookup_meaning => l_rif_reg.occ_code_desc,
501: p_lookup_desc => l_dummy_parameter);
502:
503: -- Job name - select from per_jobs - in job_id,business_group_id
504:
505: if per_rec.job_id is not null then
506: for job_name_rec in job_name(per_rec.job_id) loop
507: l_rif_reg.job_name := job_name_rec.name;