DBA Data[Home] [Help]

APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 325: pa_implementations_all imp

321: AND p_actuals_thru_date(ss1) BETWEEN pd.start_date AND pd.end_date;
322: ELSIF ( l_time_phase = 'G') THEN
323: SELECT gl.end_date INTO l_open_pd_end_date
324: FROM gl_period_statuses gl,
325: pa_implementations_all imp
326: WHERE gl.application_id = PA_PERIOD_PROCESS_PKG.Application_id
327: AND gl.set_of_books_id = imp.set_of_books_id
328: AND gl.adjustment_period_flag = 'N'
329: AND imp.org_id = l_fp_cols_rec.x_org_id -- R12 MOAC 4447573: NVL(imp.org_id,-99)

Line 403: pa_implementations_all imp

399: ELSIF ( l_time_phase = 'G') THEN
400: FOR n IN l_period_name_tab.FIRST..l_period_name_tab.LAST LOOP
401: SELECT gl.start_date, gl.end_date INTO l_start_date,l_end_date
402: FROM gl_period_statuses gl,
403: pa_implementations_all imp
404: WHERE gl.application_id = PA_PERIOD_PROCESS_PKG.Application_id
405: AND gl.SET_OF_BOOKS_ID = imp.SET_OF_BOOKS_ID
406: AND gl.ADJUSTMENT_PERIOD_FLAG = 'N'
407: AND imp.org_id = l_fp_cols_rec.x_org_id -- R12 MOAC 4447573: nvl(imp.org_id,-99)