DBA Data[Home] [Help]

APPS.PA_CREATE_RESOURCE dependencies on PA_JOBS_V

Line 628: FROM pa_jobs_v

624:
625: -- Added for Bug 2486405.
626: CURSOR c_job_group_csr IS
627: SELECT 1
628: FROM pa_jobs_v
629: WHERE job_group_id = p_job_group_id
630: AND ROWNUM = 1;
631:
632: -- Following block of code is added for the resolution of bug 1889671

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

724: RAISE NO_DATA_FOUND;
725: END IF;
726:
727: -----------------------Bug 2486405--------------------------
728: p_err_stage := 'Select 1 from pa_jobs_v ';
729:
730: If (p_job_group_id IS NULL OR
731: p_job_group_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
732: l_job_group_id := NULL;

Line 2090: pa_jobs_v

2086: CURSOR c_job_csr IS
2087: SELECT
2088: 'X'
2089: FROM
2090: pa_jobs_v
2091: WHERE job_group_id = p_job_group_id
2092: AND job_id = p_job_id;
2093:
2094: BEGIN