DBA Data[Home] [Help]

APPS.PA_MCB_REVENUE_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 119: FROM pa_draft_invoice_items drii,

115: AND ( v.calling_process||'' = 'Revenue'
116: OR ( v.calling_process||'' = 'Invoice'
117: AND EXISTS
118: (SELECT 'Invoice is released'
119: FROM pa_draft_invoice_items drii,
120: pa_draft_invoices dri
121: WHERE drii.project_id = p_project_id
122: AND nvl(drii.event_task_id, -1) = nvl( v.task_id, -1)
123: AND drii.event_num = v.event_num