APPS.PA_GENERATE_FORECAST_PUB dependencies on STANDARD

Line 1528: standard_bill_rate

1524: last_update_login,
1525: unit_of_measure,
1526: track_as_labor_flag,
1527: project_assignment_id,
1528: standard_bill_rate
1529: ) VALUES
1530: ( l_resource_assignment_id ,
1531: l_budget_version_id,
1532: p_project_id,

Line 2068: SELECT SUM( DECODE(STANDARD_BILL_RATE,0,NULL,STANDARD_BILL_RATE) * TOTAL_PLAN_QUANTITY )

2064: TOTAL_PLAN_QUANTITY > 0;
2065:
2066: /* Calculate the STD bill rate for the Project Level */
2067:
2068: SELECT SUM( DECODE(STANDARD_BILL_RATE,0,NULL,STANDARD_BILL_RATE) * TOTAL_PLAN_QUANTITY )
2069: INTO l_prj_level_revenue
2070: FROM PA_RESOURCE_ASSIGNMENTS
2071: WHERE
2072: BUDGET_VERSION_ID = l_budget_version_id AND

Line 2077: STANDARD_BILL_RATE = l_prj_level_revenue / l_tot_prj_quantity

2073: RESOURCE_ASSIGNMENT_ID <> l_prj_res_assignment_id;
2074:
2075: IF l_tot_prj_quantity > 0 AND l_prj_level_revenue IS NOT NULL THEN
2076: UPDATE PA_RESOURCE_ASSIGNMENTS SET
2077: STANDARD_BILL_RATE = l_prj_level_revenue / l_tot_prj_quantity
2078: WHERE
2079: BUDGET_VERSION_ID = l_budget_version_id AND
2080: RESOURCE_ASSIGNMENT_ID = l_prj_res_assignment_id;
2081: END IF;

Line 2085: ((STANDARD_BILL_RATE - AVERAGE_BILL_RATE)/STANDARD_BILL_RATE) * 100

2081: END IF;
2082:
2083: UPDATE PA_RESOURCE_ASSIGNMENTS RA SET
2084: AVERAGE_DISCOUNT_PERCENTAGE =
2085: ((STANDARD_BILL_RATE - AVERAGE_BILL_RATE)/STANDARD_BILL_RATE) * 100
2086: WHERE
2087: BUDGET_VERSION_ID = l_budget_version_id AND
2088: STANDARD_BILL_RATE <> 0 AND
2089: AVERAGE_BILL_RATE <> 0;

Line 2088: STANDARD_BILL_RATE <> 0 AND

2084: AVERAGE_DISCOUNT_PERCENTAGE =
2085: ((STANDARD_BILL_RATE - AVERAGE_BILL_RATE)/STANDARD_BILL_RATE) * 100
2086: WHERE
2087: BUDGET_VERSION_ID = l_budget_version_id AND
2088: STANDARD_BILL_RATE <> 0 AND
2089: AVERAGE_BILL_RATE <> 0;
2090:
2091: PA_DEBUG.g_err_stage := '3100: after updating PA_RESOURCE_ASSIGNMENTS for REVENUE';
2092: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);