DBA Data[Home] [Help]

APPS.PA_BILLING dependencies on PA_CUST_EVENT_REV_DIST_LINES

Line 842: FROM pa_cust_event_rev_dist_lines l

838: WHERE v.project_id = X_project_id
839: AND v.request_id+0 = X_request_id
840: AND (v.project_id, nvl(v.task_id, -1), v.event_num) IN
841: (SELECT l.project_id, nvl(l.task_id, -1), l.event_num
842: FROM pa_cust_event_rev_dist_lines l
843: WHERE l.project_id = X_project_id
844: AND l.line_num_reversed is null
845: AND l.draft_revenue_num = X_rev_inv_num)
846: AND EXISTS