APPS.PA_PLAN_MATRIX dependencies on PA_PROJECTS_ALL

Line 98: pa_projects_all p,

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

Line 144: pa_projects_all p

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
148: nvl(p.org_id,-99) = nvl(imp.org_id,-99) AND

Line 185: pa_projects_all p ,

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

Line 225: pa_projects_all p

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
229: nvl(p.org_id,-99) = nvl(imp.org_id,-99) AND

Line 2207: FROM pa_projects_all

2203: SELECT project_currency_code,
2204: projfunc_currency_code
2205: INTO l_project_currency_code,
2206: l_projfunc_currency_code
2207: FROM pa_projects_all
2208: WHERE project_id = l_project_id;
2209:
2210: /* Change for Bug 2641475 Ends */
2211: