APPS.PA_PURGE_VALIDATE_CAPITAL dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 125: FROM pa_project_asset_assignments paa

121: from pa_tasks pt2
122: where project_id = pp.project_id
123: and ( exists
124: (SELECT task_id
125: FROM pa_project_asset_assignments paa
126: WHERE paa.project_id = pp.project_id
127: and (paa.task_id = pt2.task_id or
128: paa.task_id = pt2.top_task_id))
129: or exists --- Return all common tasks

Line 131: FROM pa_project_asset_assignments paa

127: and (paa.task_id = pt2.task_id or
128: paa.task_id = pt2.top_task_id))
129: or exists --- Return all common tasks
130: (SELECT task_id
131: FROM pa_project_asset_assignments paa
132: WHERE paa.project_id = pp.project_id
133: and task_id = pt2.task_id
134: AND paa.project_asset_id = 0))
135: UNION

Line 140: FROM pa_project_asset_assignments paa

136: SELECT task_id
137: FROM pa_tasks
138: WHERE project_id IN
139: (SELECT project_id --- project level asset assignment
140: FROM pa_project_asset_assignments paa
141: WHERE project_id = pp.project_id
142: AND NVL(task_id, 0) = 0
143: UNION
144: SELECT project_id --- return all common tasks

Line 145: FROM pa_project_asset_assignments paa

141: WHERE project_id = pp.project_id
142: AND NVL(task_id, 0) = 0
143: UNION
144: SELECT project_id --- return all common tasks
145: FROM pa_project_asset_assignments paa
146: WHERE paa.project_id = pp.project_id
147: and NVL(paa.task_id,0) = 0
148: AND paa.project_asset_id = 0))
149: AND NOT EXISTS