APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_FORECAST_LINES

Line 257: FROM pa_org_forecast_lines fl

253: ,nvl(sum(fl.lent_resource_cost),0)
254: ,nvl(sum(fl.tp_cost_in),0)
255: ,nvl(sum(fl.tp_cost_out),0)
256: ,nvl(sum(fl.unassigned_time_cost),0)
257: FROM pa_org_forecast_lines fl
258: WHERE fl.budget_version_id = l_budget_version_id
259: AND fl.project_id = l_project_id
260: AND fl.task_id = l_own_task_id
261: GROUP BY fl.period_name

Line 2288: SELECT pa_org_forecast_lines_s.NEXTVAL

2284:
2285: l_fl_ctr := nvl(l_fl_forecast_line_id_tab.last+1,1);
2286: l_stage := 6300;
2287: -- hr_utility.trace(to_char(l_stage));
2288: SELECT pa_org_forecast_lines_s.NEXTVAL
2289: INTO l_fl_new_seq
2290: FROM DUAL;
2291:
2292: l_stage := 6400;

Line 2366: SELECT pa_org_forecast_lines_s.NEXTVAL

2362:
2363: l_stage := 6600;
2364: -- hr_utility.trace(to_char(l_stage));
2365: l_fl_ctr := nvl(l_fl_forecast_line_id_tab.last+1,1);
2366: SELECT pa_org_forecast_lines_s.NEXTVAL
2367: INTO l_fl_new_seq
2368: FROM DUAL;
2369: l_stage := 6700;
2370: -- hr_utility.trace(to_char(l_stage));

Line 2542: INSERT INTO pa_org_forecast_lines

2538: END IF;
2539:
2540: IF l_fl_forecast_line_id_tab.count > 0 THEN
2541: FORALL j in l_fl_forecast_line_id_tab.first..l_fl_forecast_line_id_tab.last
2542: INSERT INTO pa_org_forecast_lines
2543: ( forecast_line_id
2544: ,forecast_element_id
2545: ,budget_version_id
2546: ,project_id