APPS.PSP_GENERAL dependencies on PER_JOBS_V

Line 2255: from per_jobs_v pjv

2251: FUNCTION chk_job_validity(p_job_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2252:
2253: cursor eff_dates is
2254: select max(nvl(pjv.date_to,to_date('31/12/4712','DD/MM/RRRR'))),min(pjv.date_from)
2255: from per_jobs_v pjv
2256: WHERE pjv.job_id = p_job_id;
2257:
2258: max_eff_end_date date;
2259: min_eff_start_date date;

Line 2287: from per_jobs_v pjv

2283: FUNCTION get_job_name_er(p_job_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2284:
2285: cursor eff_dates is
2286: select max(nvl(pjv.date_to,to_date('31/12/4712','DD/MM/RRRR'))),min(pjv.date_from)
2287: from per_jobs_v pjv
2288: WHERE pjv.job_id = p_job_id;
2289:
2290: cursor c1(p_calculated_date date)
2291: is

Line 2293: from per_jobs_v pjv

2289:
2290: cursor c1(p_calculated_date date)
2291: is
2292: select name
2293: from per_jobs_v pjv
2294: WHERE pjv.job_id = p_job_id
2295: and p_calculated_date between pjv.date_from and trunc(nvl(pjv.date_to,to_date('31/12/4712','DD/MM/RRRR')));
2296:
2297: l_job_name varchar2(240);