APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_FORECAST_LINES

Line 258: FROM pa_org_forecast_lines fl

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

Line 2289: SELECT pa_org_forecast_lines_s.NEXTVAL

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

Line 2367: SELECT pa_org_forecast_lines_s.NEXTVAL

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

Line 2543: INSERT INTO pa_org_forecast_lines

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