APPS.PA_REV_CA dependencies on PA_DRAFT_REVENUES_ALL

Line 1478: pa_draft_revenues_all dr

1474: nvl(erdl.projfunc_revenue_amount,0),0))
1475: INTO l_accounted_cost_WIP_itd,
1476: l_cost_accrual_itd
1477: FROM pa_events pe, pa_cust_event_rdl_all erdl,
1478: pa_draft_revenues_all dr
1479: WHERE pe.event_num = erdl.event_num
1480: AND pe.project_id = erdl.project_id
1481: AND nvl(pe.task_id,0) = nvl(erdl.task_id,0)
1482: AND nvl(pe.task_id,0) =

Line 1504: pa_draft_revenues_all dr , pa_periods pp /* Bug# 2197991 */

1500: nvl(erdl.projfunc_revenue_amount,0),0))
1501: INTO l_accounted_cost_WIP_ptd,
1502: l_cost_accrual_ptd
1503: FROM pa_events pe, pa_cust_event_rdl_all erdl,
1504: pa_draft_revenues_all dr , pa_periods pp /* Bug# 2197991 */
1505: WHERE pp.current_pa_period_flag = 'Y'
1506: -- AND TRUNC(dr.pa_date) = pp.end_date
1507: AND TRUNC(dr.pa_date) BETWEEN pp.start_date AND pp.end_date -- Modified for PA/GL period enhancements
1508: AND pe.event_num = erdl.event_num

Line 1532: pa_draft_revenues_all dr,

1528: /* Changed this column from amount to projfunc_revenue_amount for MCB2 */
1529: SELECT sum(nvl(dri.projfunc_revenue_amount,0))
1530: INTO l_revenue_ptd
1531: FROM pa_draft_revenue_items dri,
1532: pa_draft_revenues_all dr,
1533: pa_periods pp /* Bug# 2197991 */
1534: WHERE dri.project_id = x_project_id
1535: AND nvl(dri.task_id,0) =
1536: decode(x_status_view,