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_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_SPREAD_CURVES_B

Line 956: l_spread_curve_code PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE;

952: l_multi_bdgt_lines NUMBER;
953:
954: -- Bug 4699248: Replaced l_spread_curve_name with l_spread_curve_code
955: -- throughout this procedure. Also, updated the type accordingly.
956: l_spread_curve_code PA_SPREAD_CURVES_B.SPREAD_CURVE_CODE%TYPE;
957:
958: l_bl_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
959:
960: l_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;

Line 2451: -- 'pa_spread_curves_b' table instead of 'pa_spread_curves_tl'.

2447: /* If the spread curve is Even then spread_curve_id
2448: and sp_fixed_date are nullified in res asg table */
2449: BEGIN
2450: -- Bug 4699248: Modified the SELECT statement below to use the
2451: -- 'pa_spread_curves_b' table instead of 'pa_spread_curves_tl'.
2452: -- As a result, the query fetches the spread curve code instead
2453: -- of the spread curve name for the given resource.
2454:
2455: SELECT ra.spread_curve_id,t.spread_curve_code

Line 2457: FROM pa_resource_assignments ra,pa_spread_curves_b t

2453: -- of the spread curve name for the given resource.
2454:
2455: SELECT ra.spread_curve_id,t.spread_curve_code
2456: INTO l_spread_curve_id,l_spread_curve_code
2457: FROM pa_resource_assignments ra,pa_spread_curves_b t
2458: WHERE ra.resource_assignment_id = p_resource_assignment_id
2459: AND ra.spread_curve_id = t.spread_curve_id;
2460: EXCEPTION
2461: WHEN NO_DATA_FOUND THEN