APPS.PA_PLAN_MATRIX dependencies on PA_PROJ_PERIOD_PROFILES

Line 431: -- pa_budget_lines table and Pa_Proj_Period_Profiles table.

427: -- End Date - l_st_dt_4_end_pd
428:
429: -- Get The Period Name, Start Date and End Date from the GL_periods
430: -- Table for the minimum of start date and end date derived from the
431: -- pa_budget_lines table and Pa_Proj_Period_Profiles table.
432:
433: -- Assigning values from cursor to the local variable
434: l_resource_assignment_id := main_cur_rec.resource_assignment_id;
435: l_transaction_currency_code := main_cur_rec.source_txn_currency_code;

Line 1724: pa_proj_period_profiles where

1720: l_period50_start_date,
1721: l_period51_start_date,
1722: l_period52_start_date
1723: from
1724: pa_proj_period_profiles where
1725: period_profile_id = p_period_profile_id;
1726: EXCEPTION
1727: WHEN NO_DATA_FOUND THEN
1728: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2183: FROM Pa_Proj_Period_Profiles pa_prof

2179: -- Getting the period_set_name and gl_period_type from period profile table
2180:
2181: SELECT pa_prof.Plan_Period_Type
2182: INTO l_plan_period_type
2183: FROM Pa_Proj_Period_Profiles pa_prof
2184: WHERE pa_prof.period_profile_id = p_period_profile_id;
2185:
2186: -- Calling the API to populate the budget lines table
2187: l_project_id := p_project_id;