APPS.PA_EVENT_CORE dependencies on PA_DRAFT_INVOICES_ALL

Line 646: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA

642: WHERE EVENT_ID=P_event_id;
643:
644: CURSOR EVENT_BILL_AMOUNT IS
645: SELECT SUM(NVL(AMOUNT,0))
646: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA
647: WHERE DI.PROJECT_ID=EV.PROJECT_ID
648: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
649: AND DI.EVENT_NUM = EV.EVENT_NUM
650: AND DI.PROJECT_ID=DIA.PROJECT_ID