APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_PROJECTS

Line 60: pa_projects t

56: from dual
57: where exists (
58: select 'X'
59: from pa_transaction_interface_all it,
60: pa_projects t
61: where it.project_number = t.segment1
62: and t.project_id = p_project_id
63: and ( p_active_flag <> 'A'
64: or (trunc(it.expenditure_item_date ) <=

Line 152: pa_projects_all p

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
155: and t.project_id = p_project_id
156: and p.project_type = pt.project_type

Line 321: select null from pa_projects pj,

317: cursor ISOrgForecastProject IS
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'

Line 336: pa_projects p

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' );
340: