DBA Data[Home] [Help]

APPS.PA_CI_DIR_COST_PUB dependencies on PA_RESOURCE_ASSIGNMENTS

Line 56: from pa_resource_assignments pra, pa_resource_asgn_curr prac

52: planning_start_date,
53: planning_end_date,
54: prac.txn_average_raw_cost_rate planning_resource_rate,
55: prac.txn_average_burden_cost_rate burden_cost_rate
56: from pa_resource_assignments pra, pa_resource_asgn_curr prac
57: where pra.budget_version_id = c_bvId
58: and pra.task_id = c_task_id
59: and pra.resource_list_member_id = c_rlmi
60: and prac.resource_assignment_id = pra.resource_assignment_id;

Line 196: from pa_resource_assignments pra, pa_resource_asgn_curr prac

192: pcdc.quantity * prac.txn_average_raw_cost_rate),
193: decode(pcdc.quantity, null,
194: pcdc.raw_cost * prac.txn_average_burden_cost_rate,
195: pcdc.quantity * prac.txn_average_burden_cost_rate)
196: from pa_resource_assignments pra, pa_resource_asgn_curr prac
197: where pra.budget_version_id = p_bvId
198: and pra.task_id = pcdc.task_id
199: and pra.resource_list_member_id = pcdc.resource_list_member_id
200: and prac.txn_currency_code = pcdc.currency_code

Line 479: from pa_resource_assignments pra, pa_resource_asgn_curr prac

475: pcdc.quantity * prac.txn_average_raw_cost_rate),
476: decode(pcdc.quantity, null,
477: pcdc.raw_cost * prac.txn_average_burden_cost_rate,
478: pcdc.quantity * prac.txn_average_burden_cost_rate)
479: from pa_resource_assignments pra, pa_resource_asgn_curr prac
480: where pra.budget_version_id = p_bvId
481: and pra.resource_assignment_id = pcdc.resource_assignment_id
482: and prac.resource_assignment_id = pra.resource_assignment_id
483: and prac.txn_currency_code = pcdc.currency_code)