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 GL_PERIOD_STATUSES

Line 324: FROM gl_period_statuses gl,

320: WHERE pd.org_id = l_fp_cols_rec.x_org_id -- R12 MOAC 4447573: NVL(pd.org_id,-99)
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'

Line 402: FROM gl_period_statuses gl,

398: END LOOP;
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'

Line 2606: gl_period_statuses start_pd,

2602: max(bl.end_date)
2603: FROM pa_resource_assignments ra,
2604: pa_budget_versions bv, -- Added for Perf Bug 4469690
2605: pa_budget_lines bl,
2606: gl_period_statuses start_pd,
2607: gl_period_statuses end_pd
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

Line 2607: gl_period_statuses end_pd

2603: FROM pa_resource_assignments ra,
2604: pa_budget_versions bv, -- Added for Perf Bug 4469690
2605: pa_budget_lines bl,
2606: gl_period_statuses start_pd,
2607: gl_period_statuses end_pd
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

Line 2709: gl_period_statuses start_pd,

2705: FROM pa_resource_assignments ra,
2706: pa_budget_versions bv, -- Added for Perf Bug 4469690
2707: pa_budget_lines bl,
2708: pji_fm_xbs_accum_tmp1 pji_tmp,
2709: gl_period_statuses start_pd,
2710: gl_period_statuses end_pd
2711: WHERE ra.resource_assignment_id = bl.resource_assignment_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

Line 2710: gl_period_statuses end_pd

2706: pa_budget_versions bv, -- Added for Perf Bug 4469690
2707: pa_budget_lines bl,
2708: pji_fm_xbs_accum_tmp1 pji_tmp,
2709: gl_period_statuses start_pd,
2710: gl_period_statuses end_pd
2711: WHERE ra.resource_assignment_id = bl.resource_assignment_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

Line 3029: FROM gl_period_statuses pd

3025: AND l_etc_start_date between pd.start_date and pd.end_date;
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;