DBA Data[Home] [Help]

APPS.PA_DRAFT_REVENUES_PKG dependencies on PA_EVENTS

Line 137: from pa_draft_invoice_items dii, pa_events e

133: where project_id = X_project_id
134: and draft_revenue_num = X_draft_revenue_num
135: union /* Start of Changes for bug 5401384 -base bug 5246804 */
136: select distinct dii.project_id,dii.draft_invoice_num
137: from pa_draft_invoice_items dii, pa_events e
138: where dii.project_id=X_project_id
139: and dii.event_num is not null
140: AND e.event_num = dii.event_num
141: and nvl(e.task_id,-99) = nvl(dii.event_task_id,-99)