APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_TASKS

Line 48: from pa_tasks pt

44: cursor ISInterPrjRecvPrj IS
45: select 'This is an Inter-Project Receiver Project'
46: from dual
47: where exists ( select NULL
48: from pa_tasks pt
49: where pt.project_id = p_project_id
50: and pt.receive_project_invoice_flag = 'Y'
51: and exists ( select NULL
52: from pa_project_customers ppc

Line 124: pa_tasks t

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'
128: and ( p_active_flag <> 'A'

Line 166: pa_tasks t

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'
170: and ei.cc_ic_processed_code = 'Y'

Line 191: pa_tasks t

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'
195: and ei.cc_ic_processed_code = 'Y'

Line 540: from pa_tasks pt

536: where ppc.bill_another_project_flag = 'Y'
537: and ppc.receiver_task_id is not null
538: and ppc.customer_bill_split <> 0 /* Bug#2429956 */
539: and ppc.receiver_task_id in ( select task_id
540: from pa_tasks pt
541: where pt.project_id = p_project_id);
542:
543: l_err_code NUMBER ;
544: l_err_stack_old VARCHAR2(2000);