APPS.PA_CREATE_RESOURCE dependencies on PA_JOBS_V

Line 616: FROM pa_jobs_v

612:
613: -- Added for Bug 2486405.
614: CURSOR c_job_group_csr IS
615: SELECT 1
616: FROM pa_jobs_v
617: WHERE job_group_id = p_job_group_id
618: AND ROWNUM = 1;
619:
620: -- Following block of code is added for the resolution of bug 1889671

Line 716: p_err_stage := 'Select 1 from pa_jobs_v ';

712: RAISE NO_DATA_FOUND;
713: END IF;
714:
715: -----------------------Bug 2486405--------------------------
716: p_err_stage := 'Select 1 from pa_jobs_v ';
717:
718: If (p_job_group_id IS NULL OR
719: p_job_group_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
720: l_job_group_id := NULL;

Line 1742: pa_jobs_v

1738: CURSOR c_job_csr IS
1739: SELECT
1740: 'X'
1741: FROM
1742: pa_jobs_v
1743: WHERE job_group_id = p_job_group_id
1744: AND job_id = p_job_id;
1745:
1746: BEGIN