7242: -- pabodla : mapping data
7243: --
7244: cursor c_get_mapping_name11(p_id in number,p_date in date) is
7245: select name
7246: from per_jobs_vl
7247: where business_group_id = p_business_group_id
7248: and job_id = p_id
7249: and p_date between date_from and nvl(date_to,p_date);
7250:
7252: --
7253:
7254: cursor c_job_start_date(c_job_id number) is
7255: select date_from
7256: from per_jobs
7257: where job_id = c_job_id;
7258:
7259: l_job_rt_id number(15);
7260: l_out_jrt_result_id number(15);
7257: where job_id = c_job_id;
7258:
7259: l_job_rt_id number(15);
7260: l_out_jrt_result_id number(15);
7261: l_job_start_date per_jobs.date_from%type;
7262: ---------------------------------------------------------------
7263: -- END OF BEN_JOB_RT_F ----------------------
7264: ---------------------------------------------------------------
7265: ---------------------------------------------------------------