DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PA_IMPLEMENTATIONS_ALL

Line 1898: FROM pa_implementations_all pia, pa_projects_all ppa WHERE pia.org_id = ppa.org_id and ppa.project_id = pProjectId;

1894: END IF;
1895:
1896: SELECT pia.fte_day
1897: INTO l_hours_per_day
1898: FROM pa_implementations_all pia, pa_projects_all ppa WHERE pia.org_id = ppa.org_id and ppa.project_id = pProjectId;
1899:
1900: /* To handle the program reporting when current version and orginal version are same
1901: * we have to generate a local table with current version orginal version in different
1902: * rows even the version id is same. So we will fix the index of those plan versions