APPS.PA_EFC_BIL dependencies on PA_DRAFT_REVENUE_ITEMS

Line 61: FROM pa_draft_revenue_items dri,

57: -- Get the total accrued revenue amount
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