APPS.PA_REV_CA dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 893: FROM pa_cost_distribution_lines_all cdl,

889: /*Change for burden shedule enhancement*/
890: SELECT sum(decode(g_ca_budget_type,'R',nvl(cdl.amount,0),
891: (nvl(cdl.burdened_cost,0)+nvl(cdl.project_burdened_change,0))))
892: INTO cost_WIP
893: FROM pa_cost_distribution_lines_all cdl,
894: pa_expenditure_items_all ei,
895: pa_tasks t
896: WHERE t.project_id = X_project_id
897: AND (t.top_task_id = X_top_task_id

Line 1045: FROM pa_cost_distribution_lines_all cdl,

1041: /* According to MCB2 changes this columns will be in PFC */
1042: SELECT sum(decode(g_ca_budget_type,'R',nvl(cdl.amount,0),
1043: (nvl(cdl.burdened_cost,0)+nvl(cdl.project_burdened_change,0))))
1044: INTO l_cost_wip_amount
1045: FROM pa_cost_distribution_lines_all cdl,
1046: pa_expenditure_items_all ei,
1047: pa_tasks t
1048: WHERE t.project_id = p_project_id
1049: AND (t.top_task_id = p_task_id

Line 1423: FROM pa_cost_distribution_lines_all cdl,

1419: /* According to MCB2 changes this columns will be in PFC */
1420: SELECT sum(decode(l_ca_budget_type,'R',nvl(cdl.amount,0),
1421: (nvl(burdened_cost,0)+nvl(cdl.project_burdened_change,0))))
1422: INTO l_raw_cost_itd
1423: FROM pa_cost_distribution_lines_all cdl,
1424: pa_expenditure_items_all ei,
1425: pa_tasks t
1426: WHERE t.project_id = x_project_id
1427: AND (nvl(t.top_task_id,0) =

Line 1448: FROM pa_cost_distribution_lines_all cdl,

1444: /* According to MCB2 changes this columns will be in PFC */
1445: SELECT sum(decode(l_ca_budget_type,'R',nvl(cdl.amount,0),
1446: (nvl(burdened_cost,0)+nvl(cdl.project_burdened_change,0))))
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'