DBA Data[Home] [Help]

APPS.PA_CI_SUPPLIER_UTILS dependencies on PA_RESOURCE_ASGN_CURR

Line 2358: from pa_resource_assignments pra, pa_resource_asgn_curr prac

2354: null,pra.planning_start_date, pcsc.FROM_CHANGE_DATE),
2355: decode(pcsc.TO_CHANGE_DATE,
2356: null, pra.planning_end_date, pcsc.TO_CHANGE_DATE),
2357: pcsc.raw_cost * prac.txn_average_burden_cost_rate
2358: from pa_resource_assignments pra, pa_resource_asgn_curr prac
2359: where pra.budget_version_id = l_budget_version_id
2360: and pra.task_id = pcsc.task_id
2361: and pra.resource_list_member_id = pcsc.resource_list_member_id
2362: and prac.txn_currency_code = pcsc.currency_code

Line 2409: from pa_resource_assignments pra, pa_resource_asgn_curr prac

2405: null,pra.planning_start_date, pcsc.FROM_CHANGE_DATE),
2406: decode(pcsc.TO_CHANGE_DATE,
2407: null, pra.planning_end_date, pcsc.TO_CHANGE_DATE),
2408: pcsc.raw_cost * prac.txn_average_burden_cost_rate
2409: from pa_resource_assignments pra, pa_resource_asgn_curr prac
2410: where pra.budget_version_id = l_budget_version_id
2411: and pra.task_id = pcsc.task_id
2412: and pra.resource_list_member_id = pcsc.resource_list_member_id
2413: and prac.txn_currency_code = pcsc.currency_code