APPS.PA_PLAN_MATRIX dependencies on GL_PERIODS

Line 96: Gl_Periods G,

92: SELECT G.period_name,
93: G.start_date,
94: G.end_date
95: FROM
96: Gl_Periods G,
97: pa_implementations_all imp ,
98: pa_projects_all p,
99: gl_sets_of_books sob
100: WHERE

Line 120: 'start date, end date and period name from GL_periods for PD-GL';

116: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
117: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
118: IF P_PA_DEBUG_MODE = 'Y' THEN
119: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
120: 'start date, end date and period name from GL_periods for PD-GL';
121: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
122: END IF;
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';

Line 142: Gl_Periods G,

138: SELECT G.period_name,
139: G.start_date,
140: G.end_date
141: FROM
142: Gl_Periods G,
143: pa_implementations_all imp ,
144: pa_projects_all p
145: WHERE
146: G.start_date < LEAST (NVL(l_min_pa_bdgt_st_dt, l_st_dt_4_st_pd), l_st_dt_4_st_pd ) AND

Line 164: 'start date, end date and period name from GL_periods for PD-PA';

160: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
161: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
162: IF P_PA_DEBUG_MODE = 'Y' THEN
163: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
164: 'start date, end date and period name from GL_periods for PD-PA';
165: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
166: END IF;
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';

Line 183: Gl_Periods G,

179: INTO x_period_name,
180: x_start_date,
181: x_end_date
182: FROM
183: Gl_Periods G,
184: pa_implementations_all imp ,
185: pa_projects_all p ,
186: gl_sets_of_books sob
187: WHERE

Line 206: 'start date, end date and period name from GL_periods for SD-GL';

202: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
203: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
204: IF P_PA_DEBUG_MODE = 'Y' THEN
205: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
206: 'start date, end date and period name from GL_periods for SD-GL';
207: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
208: END IF;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';

Line 223: Gl_Periods G,

219: INTO x_period_name,
220: x_start_date,
221: x_end_date
222: FROM
223: Gl_Periods G,
224: pa_implementations_all imp ,
225: pa_projects_all p
226: WHERE
227: G.start_date > GREATEST (NVL(l_max_pa_bdgt_st_dt, l_st_dt_4_end_pd) , l_st_dt_4_end_pd ) AND

Line 244: 'start date, end date and period name from GL_periods for SD-PA';

240: ( p_pkg_name => 'PA_PLAN_MATRIX.Get_Period_Info'
241: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
242: IF P_PA_DEBUG_MODE = 'Y' THEN
243: PA_DEBUG.g_err_stage := 'No data found while trying to retrieve ' ||
244: 'start date, end date and period name from GL_periods for SD-PA';
245: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
246: END IF;
247: x_return_status := FND_API.G_RET_STS_ERROR;
248: x_msg_data := 'PA_FP_INVALID_PROJECT_ID';

Line 429: -- Get The Period Name, Start Date and End Date from the GL_periods

425:
426: -- Start Date - l_st_dt_4_st_pd
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