849: AND dr.generation_error_flag = 'N'
850: AND dr.released_date IS NULL
851: AND dr.draft_revenue_num <=
852: (SELECT max(rdl.draft_revenue_num)
853: FROM pa_cust_event_rev_dist_lines rdl
854: WHERE rdl.project_id = P_Project_ID
855: AND rdl.draft_invoice_num = P_Draft_Invoice_Num);
856:
857:
867: AND dr.generation_error_flag = 'N'
868: AND dr.released_date IS NULL
869: AND dr.draft_revenue_num <=
870: (SELECT max(rdl.draft_revenue_num)
871: FROM pa_cust_event_rev_dist_lines rdl
872: WHERE rdl.project_id = P_Project_ID
873: and exists /* check if the event is an automatic event */
874: (select 1
875: from pa_events e, pa_event_types et