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_RATE_PVT_PKG dependencies on PA_PROJECT_ASSIGNMENTS

Line 160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;

156: l_burdened_cost_null EXCEPTION;
157: l_raw_revenue_null EXCEPTION;
158: l_no_rule EXCEPTION;
159:
160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;

Line 161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;

157: l_raw_revenue_null EXCEPTION;
158: l_no_rule EXCEPTION;
159:
160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:

Line 162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;

158: l_no_rule EXCEPTION;
159:
160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;

Line 163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;

159:
160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;

Line 164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;

160: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
161: l_expenditure_organization_id pa_project_assignments.expenditure_organization_id%TYPE;
162: l_expenditure_type pa_project_assignments.expenditure_type%TYPE;
163: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
164: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
165:
166: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
167: l_project_type pa_project_types_all.project_type%TYPE;
168: l_proj_cost_job_grp_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;

Line 345: FROM pa_project_assignments

341: SELECT NVL(expenditure_org_id,-99), expenditure_organization_id, expenditure_type,
342: fcst_job_id, fcst_job_group_id
343: INTO l_expenditure_org_id,l_expenditure_organization_id,l_expenditure_type,
344: l_forecast_job_id,l_forecast_job_group_id
345: FROM pa_project_assignments
346: WHERE project_id = p_project_id
347: AND assignment_id = p_item_id;
348:
349: IF g1_debug_mode = 'Y' THEN

Line 391: FROM pa_project_assignments

387: END IF;
388:
389: SELECT expenditure_type
390: INTO l_expenditure_type
391: FROM pa_project_assignments
392: WHERE project_id = p_project_id
393: AND assignment_id = p_item_id;
394: -- dbms_output.put_line(' after all assignment select ');
395:

Line 2107: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;

2103: l_no_rule EXCEPTION;
2104:
2105: l_calculate_cost_flag VARCHAR2(1); /* Added to fix bug 2162965 */
2106:
2107: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
2108: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
2109:
2110: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
2111:

Line 2108: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;

2104:
2105: l_calculate_cost_flag VARCHAR2(1); /* Added to fix bug 2162965 */
2106:
2107: l_forecast_job_id pa_project_assignments.fcst_job_id%TYPE;
2108: l_forecast_job_group_id pa_project_assignments.fcst_job_group_id%TYPE;
2109:
2110: l_labor_cost_mult_name pa_tasks.labor_cost_multiplier_name%TYPE;
2111:
2112:

Line 3091: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;

3087: IS
3088: l_rate_calc_date DATE;
3089: l_rate_calc_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
3090: l_quantity NUMBER;
3091: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
3092: l_expenditure_orgz_id pa_project_assignments.expenditure_organization_id%TYPE;
3093: /* MCB2 related changes */
3094: l_projfunc_bill_rate NUMBER;
3095: l_projfunc_raw_revenue NUMBER;

Line 3092: l_expenditure_orgz_id pa_project_assignments.expenditure_organization_id%TYPE;

3088: l_rate_calc_date DATE;
3089: l_rate_calc_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
3090: l_quantity NUMBER;
3091: l_expenditure_org_id pa_project_assignments.expenditure_org_id%TYPE;
3092: l_expenditure_orgz_id pa_project_assignments.expenditure_organization_id%TYPE;
3093: /* MCB2 related changes */
3094: l_projfunc_bill_rate NUMBER;
3095: l_projfunc_raw_revenue NUMBER;
3096: l_projfunc_raw_cost NUMBER;