eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_GENERATE_FORECAST_PUB dependencies on PA_PROJECT_ASSIGNMENTS

Line 289: PA_PROJECT_ASSIGNMENTS PA,

285: PA.EXPENDITURE_ORG_ID,
286: PA.STATUS_CODE,
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

Line 461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;

457: l_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE;
458: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
459: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
460:
461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%TYPE;

458: l_version_number PA_BUDGET_VERSIONS.VERSION_NUMBER%TYPE;
459: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
460:
461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 463: l_prj_resource_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;

459: l_plan_processing_code PA_BUDGET_VERSIONS.PLAN_PROCESSING_CODE%TYPE;
460:
461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 464: l_prj_project_role_id PA_PROJECT_ASSIGNMENTS.PROJECT_ROLE_ID%TYPE;

460:
461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 465: l_prj_fcst_job_id PA_PROJECT_ASSIGNMENTS.FCST_JOB_ID%TYPE;

461: l_prj_assignment_id PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_ID%TYPE;
462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 466: l_prj_fcst_job_group_id PA_PROJECT_ASSIGNMENTS.FCST_JOB_GROUP_ID%TYPE;

462: l_prj_start_date PA_PROJECT_ASSIGNMENTS.START_DATE%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;

Line 468: l_prj_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;

Line 469: l_prj_exp_org_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORG_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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;

Line 470: l_prj_exp_organization_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORGANIZATION_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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;

Line 471: l_prj_expenditure_org_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORG_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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

Line 472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

Line 473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
477:

Line 474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%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;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
477:
478:

Line 475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;

471: l_prj_expenditure_org_id PA_PROJECT_ASSIGNMENTS.EXPENDITURE_ORG_ID%TYPE;
472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
477:
478:
479:

Line 476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;

472: l_prj_exp_type PA_PROJECT_ASSIGNMENTS.EXPENDITURE_TYPE%TYPE;
473: l_prj_person_id PA_PROJECT_ASSIGNMENTS.RESOURCE_ID%TYPE;
474: l_prj_revenue_bill_rate PA_PROJECT_ASSIGNMENTS.REVENUE_BILL_RATE%TYPE;
475: l_prj_short_assignment_type PA_PROJECT_ASSIGNMENTS.ASSIGNMENT_TYPE%TYPE;
476: l_prj_status_code PA_PROJECT_ASSIGNMENTS.STATUS_CODE%TYPE;
477:
478:
479:
480: