DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PER_JOBS

Line 2350: FROM PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ

2346: OR (l_proj_fcst_job_group_id(i) IS NULL) THEN
2347: BEGIN
2348: SELECT PR.DEFAULT_JOB_ID,PJ.JOB_GROUP_ID
2349: INTO l_proj_fcst_job_id(i),l_proj_fcst_job_group_id(i)
2350: FROM PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ
2351: WHERE PR.PROJECT_ROLE_ID = l_proj_project_role_id(i)
2352: AND PJ.JOB_ID = PR.DEFAULT_JOB_ID;
2353: EXCEPTION
2354: WHEN NO_DATA_FOUND THEN