DBA Data[Home] [Help]

APPS.PA_FP_GEN_BUDGET_AMT_PUB dependencies on PA_SPREAD_CURVES_B

Line 5839: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;

5835: l_txn_resource_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
5836:
5837: /* Variables for Manually Added Plan Lines logic */
5838: l_etc_start_date DATE;
5839: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
5840: BEGIN
5841: X_MSG_COUNT := 0;
5842: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5843:

Line 6180: FROM pa_spread_curves_b

6176: -- Bug 4159172: Moved update of sp_fixed_date from CREATE_RES_ASG to here.
6177:
6178: SELECT spread_curve_id
6179: INTO l_spread_curve_id
6180: FROM pa_spread_curves_b
6181: WHERE spread_curve_code = 'FIXED_DATE';
6182:
6183: UPDATE PA_RESOURCE_ASSIGNMENTS
6184: SET SP_FIXED_DATE = PLANNING_START_DATE