DBA Data[Home] [Help]

APPS.PER_JBR_BUS dependencies on PER_JOBS_V

Line 18: -- PER_JOBS_V view .

14: -- ----------------------------------------------------------------------------
15: --
16: -- Description:
17: -- This procedure validates that the job_id exists in the
18: -- PER_JOBS_V view .
19: --
20: -- The procedure also validates that the combination of job id
21: -- and analysis criteria id, do not already exist in the job requirement
22: -- table. This procedure does not do the mandatory check, because

Line 60: from per_jobs_v pj

56: l_api_updating boolean;
57: --
58: cursor csr_job_exists is
59: select 'x'
60: from per_jobs_v pj
61: where pj.job_id = p_job_id
62: and pj.business_group_id + 0 = p_business_group_id;
63: --
64: cursor csr_combo_exists is