APPS.PA_PWP_SUMM_PKG dependencies on PA_IMPLEMENTATIONS

Line 42: FROM pa_implementations;

38: FROM PA_PWP_CUSTOMER_SUMM WHERE project_id = P_Project_Id ;
39: /* Bug 12534894
40: SELECT org_id
41: INTO l_org_id
42: FROM pa_implementations;
43: */
44:
45: --Insert the Invoice level attributes to the temp Table
46: INSERT

Line 190: , pa_implementations pa

186: , end_date
187: INTO l_start_date
188: ,l_end_date
189: FROM gl_period_statuses GL1
190: , pa_implementations pa
191: WHERE GL1.set_of_books_id = pa.set_of_books_id
192: AND GL1.APPLICATION_ID = 101 --bug 8208525
193: AND GL1.CLOSING_STATUS = 'O'
194: AND start_date =

Line 207: pa_implementations pa ,

203: GL1.end_date
204: INTO l_start_date ,
205: l_end_date
206: FROM gl_period_statuses GL1 ,
207: pa_implementations pa ,
208: pa_projects ppa
209: WHERE PPA.project_id = P_Project_Id
210: AND pa.org_id = ppa.org_id
211: AND GL1.set_of_books_id = pa.set_of_books_id

Line 218: pa_implementations pa2 ,

214: AND GL1.ADJUSTMENT_PERIOD_FLAG = 'N'
215: AND GL1.EFFECTIVE_PERIOD_NUM =
216: (SELECT MAX(GL2.EFFECTIVE_PERIOD_NUM)
217: FROM gl_period_statuses GL2 ,
218: pa_implementations pa2 ,
219: pa_projects ppa2
220: WHERE PPA2.project_id = P_Project_Id
221: AND pa2.org_id = ppa2.org_id
222: AND GL2.set_of_books_id = pa2.set_of_books_id