APPS.PA_EVENT_CORE dependencies on PA_DRAFT_INVOICE_ITEMS

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

644: /*Bug 16245626 replaced di.task_id with di.event_task_id */
645:
646: CURSOR EVENT_BILL_AMOUNT IS
647: SELECT SUM(NVL(AMOUNT,0))
648: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV,PA_DRAFT_INVOICES_ALL DIA
649: WHERE DI.PROJECT_ID=EV.PROJECT_ID
650: AND nvl(DI.EVENT_TASK_ID,-1) =nvl(EV.TASK_ID,-1)
651: AND DI.EVENT_NUM = EV.EVENT_NUM
652: AND DI.PROJECT_ID=DIA.PROJECT_ID

Line 659: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;

655: AND EV.EVENT_ID = P_event_id;
656:
657: l_rev_flag VARCHAR2(1);
658: l_billed_flag VARCHAR2(1);
659: L_BILL_AMOUNT pa_draft_invoice_items.amount%type;
660: l_invoiced_flag VARCHAR2(1):= 'N';
661: l_bill_trans_bill_amount pa_events.bill_trans_bill_amount%type; /* Added for bug#9370006 */
662: l_bill_trans_rev_amount pa_events.bill_trans_rev_amount%type; /* Added for bug#9370006 */
663: BEGIN

Line 686: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV

682: SELECT 1
683: INTO dummy
684: FROM DUAL
685: WHERE EXISTS ( SELECT NULL
686: FROM PA_DRAFT_INVOICE_ITEMS DI,PA_EVENTS EV
687: WHERE DI.project_id=EV.project_id
688: AND nvl(DI.TASK_ID,-1) =nvl(EV.TASK_ID,-1)
689: AND DI.EVENT_NUM = EV.EVENT_NUM
690: AND EV.EVENT_ID = P_event_id);