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