DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECTS_ALL

Line 65: FROM pa_projects_all ppr, -- Changed to _all as part of MOAC changes.

61: ppr.name project_name,
62: pt.task_id,
63: ppr.project_id,
64: pei.expenditure_item_id
65: FROM pa_projects_all ppr, -- Changed to _all as part of MOAC changes.
66: pa_project_types ppt,
67: -- pa_cost_distribution_lines_all pcdl,
68: pa_expenditure_items_all pei,
69: pa_tasks pt,

Line 552: pa_projects_all pp -- Changed to _ALL as part of MOAC changes

548: select 'X'
549: from pa_tasks pt,
550: pa_tasks pt2,
551: pa_project_types ppt,
552: pa_projects_all pp -- Changed to _ALL as part of MOAC changes
553: where pp.project_type = ppt.project_type
554: and ppt.cip_grouping_method_code = 'CIPGCE'
555: --and nvl(ppt.attribute10,'N') = 'Y'
556: and pp.project_id = x_project_id