APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_PROJECT_ROLE_TYPES

Line 291: PA_PROJECT_ROLE_TYPES PR

287: WB.BILLABLE_CAPITALIZABLE_FLAG --Added for the bug 2420564
288: FROM
289: PA_PROJECT_ASSIGNMENTS PA,
290: PA_WORK_TYPES_B WB,
291: PA_PROJECT_ROLE_TYPES PR
292: WHERE
293: PA.PROJECT_ID = p_project_id AND
294: PA.PROJECT_ROLE_ID = PR.PROJECT_ROLE_ID AND
295: WB.WORK_TYPE_ID = PA.WORK_TYPE_ID(+); --Added for the bug 2420564

Line 467: l_prj_meaning PA_PROJECT_ROLE_TYPES.MEANING%TYPE;

463: l_prj_resource_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
464: l_prj_project_role_id PA_PROJECT_ASSIGNMENTS.PROJECT_ROLE_ID%TYPE;
465: l_prj_fcst_job_id PA_PROJECT_ASSIGNMENTS.FCST_JOB_ID%TYPE;
466: l_prj_fcst_job_group_id PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID%TYPE;
467: l_prj_meaning PA_PROJECT_ROLE_TYPES.MEANING%TYPE;
468: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
469: l_prj_exp_org_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORG_ID%TYPE;
470: l_prj_exp_organization_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORGANIZATION_ID%TYPE;
471: l_prj_expenditure_org_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORG_ID%TYPE;

Line 908: PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ

904: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
905: BEGIN
906: SELECT PR.DEFAULT_JOB_ID,PJ.JOB_GROUP_ID INTO
907: l_prj_fcst_job_id,l_prj_fcst_job_group_id FROM
908: PA_PROJECT_ROLE_TYPES PR, PER_JOBS PJ
909: WHERE
910: PR.PROJECT_ROLE_ID = l_prj_project_role_id AND
911: PJ.JOB_ID = PR.DEFAULT_JOB_ID;
912: EXCEPTION