DBA Data[Home] [Help]

APPS.PA_PLAN_MATRIX dependencies on PA_IMPLEMENTATIONS_ALL

Line 97: pa_implementations_all imp ,

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
101: 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 143: pa_implementations_all imp ,

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
147: p.project_id = l_project_id AND

Line 184: pa_implementations_all imp ,

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
188: 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 224: pa_implementations_all imp ,

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
228: p.project_id = l_project_id AND