APPS.PA_REV_CA dependencies on PA_CUST_EVENT_RDL_ALL

Line 1477: FROM pa_events pe, pa_cust_event_rdl_all erdl,

1473: sum(decode(pe.event_type,l_ca_event_type,
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)

Line 1503: FROM pa_events pe, pa_cust_event_rdl_all erdl,

1499: sum(decode(pe.event_type,l_ca_event_type,
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