DBA Data[Home] [Help]

APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_BUDGET_LINES

Line 2326: --Pa_Fin_Plan_Lines_Tmp table from the records in the Pa_Budget_Lines

2322:
2323: --This API is called on refresh of period profiles.
2324: --The API deletes current record from the pa_proj_periods_denorm table
2325: --for the budget version passed to it. It then populates the
2326: --Pa_Fin_Plan_Lines_Tmp table from the records in the Pa_Budget_Lines
2327: --table. The API then calls the Maintain Plan Matrix API to populate
2328: --the budget lines table with preceding and succeeding period values and
2329: --inserts the current period amounts in the pa_proj_periods_denorm table
2330:

Line 3248: from pa_budget_lines

3244: BEGIN
3245: l_return_value := 'N';
3246: select unique 'Y'
3247: into l_return_value
3248: from pa_budget_lines
3249: where budget_version_id = p_budget_version_id and
3250: bucketing_period_code = 'PD';
3251: return l_return_value;
3252: EXCEPTION

Line 3266: from pa_budget_lines

3262: BEGIN
3263: l_return_value := 'N';
3264: select unique 'Y'
3265: into l_return_value
3266: from pa_budget_lines
3267: where budget_version_id = p_budget_version_id and
3268: bucketing_period_code = 'SD';
3269: return l_return_value;
3270: EXCEPTION