DBA Data[Home] [Help]

APPS.PA_EFC_BIL dependencies on PA_DRAFT_REVENUES_ALL

Line 62: pa_draft_revenues_all dr

58:
59: SELECT NVL(SUM(dri.amount),0) dri_amount
60: INTO pl_accr_rev
61: FROM pa_draft_revenue_items dri,
62: pa_draft_revenues_all dr
63: WHERE dri.project_id = dr.project_id
64: AND dri.draft_revenue_num = dr.draft_revenue_num
65: AND ( NVL(p_task_id,0) = 0
66: OR dri.task_id = p_task_id )