APPS.PA_EVENTS_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 824: FROM pa_draft_invoice_items dii

820: SELECT 'Y'
821: FROM sys.dual
822: WHERE EXISTS(
823: SELECT 'Event is on invoice item'
824: FROM pa_draft_invoice_items dii
825: WHERE dii.project_id = X_project_id
826: AND NVL(dii.event_task_id,-1) = NVL(X_Task_Id,-1)
827: AND dii.event_num = X_Event_Num
828: );

Line 892: FROM pa_draft_invoice_items dii

888: IF nvl(x_bill_amount,0) <> 0 THEN
889: if ( x_task_id is not null ) then
890: SELECT decode(nvl(sum(dii.amount),0),0,'N','Y')
891: INTO v_IsEventBilled
892: FROM pa_draft_invoice_items dii
893: WHERE dii.project_id = x_project_id
894: AND dii.event_task_id = x_task_id
895: AND dii.event_num = x_event_num;
896: else

Line 899: FROM pa_draft_invoice_items dii

895: AND dii.event_num = x_event_num;
896: else
897: SELECT decode(nvl(sum(dii.amount),0),0,'N','Y')
898: INTO v_IsEventBilled
899: FROM pa_draft_invoice_items dii
900: WHERE dii.project_id = x_project_id
901: AND dii.event_num = x_event_num
902: AND dii.event_task_id IS NULL;
903: end if;