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'
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'
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'