DBA Data[Home] [Help]

APPS.PA_INVOICE_ACTIONS dependencies on PA_CUST_EVENT_REV_DIST_LINES

Line 853: FROM pa_cust_event_rev_dist_lines rdl

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:

Line 871: FROM pa_cust_event_rev_dist_lines rdl

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