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_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_PERIOD_PROCESS_PKG

Line 326: WHERE gl.application_id = PA_PERIOD_PROCESS_PKG.Application_id

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)
330: AND p_actuals_thru_date(ss1) BETWEEN gl.start_date AND gl.end_date;

Line 404: WHERE gl.application_id = PA_PERIOD_PROCESS_PKG.Application_id

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)
408: AND gl.period_name = l_period_name_tab(n);

Line 2612: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2608: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2609: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2610: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2611: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690
2612: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2613: AND start_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2614: AND start_pd.adjustment_period_flag = 'N'
2615: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2616: AND end_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id

Line 2615: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2611: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690
2612: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2613: AND start_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2614: AND start_pd.adjustment_period_flag = 'N'
2615: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2616: AND end_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2617: AND end_pd.adjustment_period_flag = 'N'
2618: AND ra.planning_start_date between start_pd.start_date and start_pd.end_date
2619: AND ra.planning_end_date between end_pd.start_date and end_pd.end_date

Line 2716: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2712: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2713: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2714: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690
2715: AND ra.resource_assignment_id = pji_tmp.source_id
2716: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2717: AND start_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2718: AND start_pd.adjustment_period_flag = 'N'
2719: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2720: AND end_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id

Line 2719: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

2715: AND ra.resource_assignment_id = pji_tmp.source_id
2716: AND start_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2717: AND start_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2718: AND start_pd.adjustment_period_flag = 'N'
2719: AND end_pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
2720: AND end_pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
2721: AND end_pd.adjustment_period_flag = 'N'
2722: AND ra.planning_start_date between start_pd.start_date and start_pd.end_date
2723: AND ra.planning_end_date between end_pd.start_date and end_pd.end_date

Line 3030: WHERE pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id

3026: ELSIF l_fp_cols_rec.x_time_phased_code = 'G' THEN
3027: SELECT pd.end_date
3028: INTO l_etc_start_period_end_date
3029: FROM gl_period_statuses pd
3030: WHERE pd.application_id = PA_PERIOD_PROCESS_PKG.Application_id
3031: AND pd.set_of_books_id = l_fp_cols_rec.x_set_of_books_id
3032: AND pd.adjustment_period_flag = 'N'
3033: AND l_etc_start_date between pd.start_date and pd.end_date;
3034: END IF;