DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_COSTING dependencies on PA_TASKS

Line 151: pa_tasks t,

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

Line 173: pa_tasks t

169: from dual
170: where exists (
171: select ei.expenditure_item_id
172: from pa_expenditure_items_all ei,
173: pa_tasks t
174: where ei.task_id = t.task_id
175: and t.project_id = p_project_id
176: and ei.cc_cross_charge_code = 'I')
177: or exists (

Line 277: from pa_tasks pt

273: cursor ISInterPrjRecvPrj IS
274: select 'This is an Inter-Project Receiver Project'
275: from dual
276: where exists ( select NULL
277: from pa_tasks pt
278: where pt.project_id = p_project_id
279: and pt.receive_project_invoice_flag = 'Y'
280: and exists ( select NULL
281: from pa_project_customers ppc