APPS.PA_REV_CA dependencies on PA_PERIODS

Line 1451: pa_periods pp

1447: INTO l_raw_cost_ptd
1448: FROM pa_cost_distribution_lines_all cdl,
1449: pa_expenditure_items_all ei,
1450: pa_tasks t,
1451: pa_periods pp
1452: WHERE pp.current_pa_period_flag = 'Y'
1453: AND TRUNC(cdl.pa_date) BETWEEN pp.start_date AND pp.end_date
1454: AND t.project_id = x_project_id
1455: AND (nvl(t.top_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 1533: pa_periods pp /* Bug# 2197991 */

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,
1537: 'TASKS', x_task_id , nvl(dri.task_id,0))