APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_PROJECT_TYPES

Line 150: pa_project_types_all pt,

146: from dual
147: where exists (
148: select ei.expenditure_item_id
149: from pa_expenditure_items_all ei,
150: pa_project_types_all pt,
151: pa_tasks t,
152: pa_projects_all p
153: where ei.task_id = t.task_id
154: and t.project_id = p.project_id

Line 233: from pa_project_types

229: select 'This project is defined as a destination project in project type'
230: from dual
231: where exists (
232: select project_type
233: from pa_project_types
234: where burden_sum_dest_project_id = p_project_id
235: );
236:
237: /*******************************************************************************

Line 322: pa_project_types pt

318: select 'Organization Forecast Project'
319: from dual
320: where exists (
321: select null from pa_projects pj,
322: pa_project_types pt
323: where pj.project_id = p_project_id
324: and pj.project_type = pt.project_type
325: and pt.org_project_flag = 'Y'
326: );

Line 335: from pa_project_types pt,

331: cursor IsUnassignedTimeType IS
332: select 'Unassigned Time Project Type'
333: from dual
334: where exists ( select pt.project_type
335: from pa_project_types pt,
336: pa_projects p
337: where p.project_id = p_project_id
338: and pt.project_type = p.project_type
339: and nvl(pt.unassigned_time, 'N') = 'Y' );