DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_ORG_FCST_ELEMENTS_S

Line 4843: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;

4839: END IF;
4840: open l_fe_csr;
4841: loop
4842: /* generate next forecast_element_id into local variable */
4843: select pa_org_fcst_elements_s.nextVal into l_forecast_element_id from dual;
4844: fetch l_fe_csr into l_fe_rec;
4845: exit when l_fe_csr%NOTFOUND;
4846: insert into pa_org_fcst_elements (
4847: creation_date,