APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJECT_ROLE_TYPES

Line 992: PA_PROJECT_ROLE_TYPES PR,

988: FI.EXPENDITURE_ORGANIZATION_ID,
989: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
990: FROM PA_PROJECT_ASSIGNMENTS PA,
991: PA_WORK_TYPES_B WB,
992: PA_PROJECT_ROLE_TYPES PR,
993: PA_PROJECTS_ALL P,
994: PA_RESOURCE_TXN_ATTRIBUTES RTA,
995: PA_FORECAST_ITEMS FI
996: WHERE PA.PROJECT_ID = p_project_id

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