DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on PA_PROJECT_TYPES

Line 66: pa_project_types ppt,

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,
70: pa_tasks pt2

Line 551: pa_project_types ppt,

547: cursor check_auto_asset is
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'