DBA Data[Home] [Help]

APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 123: from pa_expenditure_items_all ei,

119: select 'INTERCOMPANY INV NOT GENERATED'
120: from dual
121: where exists (
122: select ei.expenditure_item_id
123: from pa_expenditure_items_all ei,
124: pa_tasks t
125: where ei.task_id = t.task_id
126: and t.project_id = p_project_id
127: and ei.cc_cross_charge_code = 'I'

Line 165: from pa_expenditure_items_all ei,

161: select 'IC INV NOT TIEDBACK SUCCESSFULLY'
162: from dual
163: where exists (
164: select null
165: from pa_expenditure_items_all ei,
166: pa_tasks t
167: where ei.task_id = t.task_id
168: and t.project_id = p_project_id
169: and ei.cc_cross_charge_code = 'I'

Line 190: from pa_expenditure_items_all ei,

186: select 'IC INV NOT ACCEPTED IN AP'
187: from dual
188: where exists (
189: select null
190: from pa_expenditure_items_all ei,
191: pa_tasks t
192: where ei.task_id = t.task_id
193: and t.project_id = p_project_id
194: and ei.cc_cross_charge_code = 'I'