APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJECT_ROLE_TYPES

Line 1004: PA_PROJECT_ROLE_TYPES PR,

1000: FI.EXPENDITURE_ORGANIZATION_ID,
1001: DECODE(PA.EXPENDITURE_TYPE,null,NULL,'EXPENDITURE_TYPE')
1002: FROM PA_PROJECT_ASSIGNMENTS PA,
1003: PA_WORK_TYPES_B WB,
1004: PA_PROJECT_ROLE_TYPES PR,
1005: PA_PROJECTS_ALL P,
1006: PA_RESOURCE_TXN_ATTRIBUTES RTA,
1007: PA_FORECAST_ITEMS FI
1008: WHERE PA.PROJECT_ID = p_project_id

Line 2362: FROM PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ

2358: OR (l_proj_fcst_job_group_id(i) IS NULL) THEN
2359: BEGIN
2360: SELECT PR.DEFAULT_JOB_ID,PJ.JOB_GROUP_ID
2361: INTO l_proj_fcst_job_id(i),l_proj_fcst_job_group_id(i)
2362: FROM PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ
2363: WHERE PR.PROJECT_ROLE_ID = l_proj_project_role_id(i)
2364: AND PJ.JOB_ID = PR.DEFAULT_JOB_ID;
2365: EXCEPTION
2366: WHEN NO_DATA_FOUND THEN