eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PWP_SUMM_PKG dependencies on PA_PROJECTS

Line 208: pa_projects ppa

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
212: AND GL1.APPLICATION_ID = 101

Line 219: pa_projects ppa2

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
223: AND GL2.APPLICATION_ID = 101

Line 299: from pa_projects_all pa where pwp.project_id = pa.project_id )

295:
296: UPDATE PA_PWP_CUSTOMER_SUMM pwp
297: SET (PROJFUNC_CURRENCY_CODE ,PROJECT_CURRENCY_CODE)
298: = (select PROJFUNC_CURRENCY_CODE, PROJECT_CURRENCY_CODE
299: from pa_projects_all pa where pwp.project_id = pa.project_id )
300: Where project_id = P_Project_Id;
301:
302:
303: -- Updating the PC/PFC amounts by convertig the INV amount fetched from AR