APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_BUDGET_LINES

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

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

Line 3191: from pa_budget_lines

3187: BEGIN
3188: l_return_value := 'N';
3189: select unique 'Y'
3190: into l_return_value
3191: from pa_budget_lines
3192: where budget_version_id = p_budget_version_id and
3193: bucketing_period_code = 'PD';
3194: return l_return_value;
3195: EXCEPTION

Line 3209: from pa_budget_lines

3205: BEGIN
3206: l_return_value := 'N';
3207: select unique 'Y'
3208: into l_return_value
3209: from pa_budget_lines
3210: where budget_version_id = p_budget_version_id and
3211: bucketing_period_code = 'SD';
3212: return l_return_value;
3213: EXCEPTION