APPS.PA_EVENT_CORE dependencies on PA_DRAFT_INVOICE_ITEMS

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

Line 657: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;

653: AND EV.EVENT_ID = P_event_id;
654:
655: l_rev_flag VARCHAR2(1);
656: l_billed_flag VARCHAR2(1);
657: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;
658: l_invoiced_flag VARCHAR2(1):= 'N';
659: BEGIN
660:
661: OPEN EVENT_PROCESSED;

Line 681: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV

677: SELECT 1
678: INTO dummy
679: FROM DUAL
680: WHERE EXISTS ( SELECT NULL
681: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV
682: WHERE DI.project_id=EV.project_id
683: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
684: AND DI.EVENT_NUM = EV.EVENT_NUM
685: AND EV.EVENT_ID = P_event_id);