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_PERIODS_ALL

Line 319: FROM pa_periods_all pd

315:
316: IF l_struct_ver_id_tab.count > 0 THEN
317: IF (l_time_phase = 'P') THEN
318: SELECT pd.end_date INTO l_open_pd_end_date
319: FROM pa_periods_all pd
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

Line 393: FROM pa_periods_all pd

389:
390: IF (l_time_phase = 'P') THEN
391: FOR m IN 1..l_period_name_tab.count LOOP
392: SELECT pd.start_date ,pd.end_date into l_start_date, l_end_date
393: FROM pa_periods_all pd
394: WHERE pd.org_id = l_fp_cols_rec.x_org_id -- R12 MOAC 4447573: nvl(pd.org_id,-99)
395: AND pd.period_name = l_period_name_tab(m);
396: l_amt_dtls_tbl(m).start_date := l_start_date;
397: l_amt_dtls_tbl(m).end_date := l_end_date;

Line 2579: pa_periods_all start_pd,

2575: max(bl.end_date)
2576: FROM pa_resource_assignments ra,
2577: pa_budget_versions bv, -- Added for Perf Bug 4469690
2578: pa_budget_lines bl,
2579: pa_periods_all start_pd,
2580: pa_periods_all end_pd
2581: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2582: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2583: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690

Line 2580: pa_periods_all end_pd

2576: FROM pa_resource_assignments ra,
2577: pa_budget_versions bv, -- Added for Perf Bug 4469690
2578: pa_budget_lines bl,
2579: pa_periods_all start_pd,
2580: pa_periods_all end_pd
2581: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2582: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2583: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2584: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690

Line 2680: pa_periods_all start_pd,

2676: FROM pa_resource_assignments ra,
2677: pa_budget_versions bv, -- Added for Perf Bug 4469690
2678: pa_budget_lines bl,
2679: pji_fm_xbs_accum_tmp1 pji_tmp,
2680: pa_periods_all start_pd,
2681: pa_periods_all end_pd
2682: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2683: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2684: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690

Line 2681: pa_periods_all end_pd

2677: pa_budget_versions bv, -- Added for Perf Bug 4469690
2678: pa_budget_lines bl,
2679: pji_fm_xbs_accum_tmp1 pji_tmp,
2680: pa_periods_all start_pd,
2681: pa_periods_all end_pd
2682: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2683: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2684: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2685: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690

Line 3023: FROM pa_periods_all pd

3019: l_etc_start_period_end_date := l_etc_start_date;
3020: IF l_fp_cols_rec.x_time_phased_code = 'P' THEN
3021: SELECT pd.end_date
3022: INTO l_etc_start_period_end_date
3023: FROM pa_periods_all pd
3024: WHERE pd.org_id = l_fp_cols_rec.x_org_id
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