DBA Data[Home] [Help]

APPS.PA_CLIENT_EXTN_PROJ_STATUS dependencies on PA_PROJECT_TYPES_ALL

Line 271: FROM pa_project_types_all -- Bug#3807805 : Modified pa_project_types to pa_project_types_all

267: /*
268: --MOAC Changes: Bug 4363092: removed nvl usage with org_id
269: CURSOR l_sel_proj_type_csr IS
270: select NVL(enable_project_wf_flag,'N')
271: FROM pa_project_types_all -- Bug#3807805 : Modified pa_project_types to pa_project_types_all
272: WHERE project_type = x_project_type
273: and org_id = PA_PROJECT_REQUEST_PVT.G_ORG_ID; -- Added the and condition for Bug#3807805
274: */
275:

Line 284: PA_PROJECT_TYPES_ALL PPT,

280: SELECT
281: PPT.org_id,
282: NVL(PPT.enable_project_wf_flag,'N')
283: FROM
284: PA_PROJECT_TYPES_ALL PPT,
285: PA_PROJECTS_ALL PPA
286: WHERE
287: PPA.org_id = PPT.org_id AND
288: PPA.project_type = PPT.project_type AND