APPS.PA_PURGE_VALIDATE_ICIP dependencies on PA_PROJECT_CUSTOMERS

Line 11: from pa_project_customers ppc

7: cursor ISInterPrjRPrvdrPrj is
8: select 'This is an Inter-Project Provider Project'
9: from dual
10: where exists ( select NULL
11: from pa_project_customers ppc
12: where ppc.project_id = p_project_id
13: and ppc.bill_another_project_flag = 'Y'
14: and ppc.receiver_task_id is not null
15: );

Line 52: from pa_project_customers ppc

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
53: where ppc.receiver_task_id = pt.task_id )
54: );
55:
56: l_dummy VARCHAR2(100);

Line 371: pa_project_customers ppc,

367: from dual
368: where exists (
369: select null
370: from pa_draft_invoices_all di,
371: pa_project_customers ppc,
372: pa_agreements_all pag
373: where di.project_id = p_project_id
374: and di.agreement_id = pag.agreement_id
375: and pag.customer_id = ppc.customer_id

Line 388: pa_project_customers ppc,

384: from dual
385: where exists (
386: select null
387: from pa_draft_invoices_all di,
388: pa_project_customers ppc,
389: pa_agreements_all pag
390: where di.project_id = p_project_id
391: and di.project_id = ppc.project_id
392: and di.agreement_id = pag.agreement_id

Line 535: from pa_project_customers ppc

531: /* cursor to get all the provider projects associated with the given receiver project */
532:
533: cursor c_provider_projects is
534: select ppc.project_id
535: from pa_project_customers ppc
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