DBA Data[Home] [Help]

APPS.PA_PROGRESS_UTILS dependencies on PA_BUDGET_LINES

Line 3041: FROM pa_budget_lines

3037: projfunc_cost_rate_type,
3038: projfunc_cost_rate_date_type,
3039: projfunc_cost_rate_date,
3040: projfunc_cost_exchange_rate
3041: FROM pa_budget_lines
3042: where budget_version_id = c_budget_version_id
3043: and resource_assignment_id = c_res_assignment_id
3044: and c_as_of_date between start_date and end_date
3045: and txn_currency_code = c_txn_curr_code;

Line 8536: FROM pa_budget_lines

8532: CURSOR get_override_rate ( c_budget_version_id NUMBER, c_resource_assignment_id NUMBER )
8533: IS
8534: SELECT NVL(TXN_COST_RATE_OVERRIDE,TXN_STANDARD_COST_RATE) -- Bug 3951555, Added nvl and TXN_STANDARD_COST_RATE
8535: , nvl(BURDEN_COST_RATE_OVERRIDE, BURDEN_COST_RATE) -- Bug 3951555, Added nvl and BURDEN_COST_RATE
8536: FROM pa_budget_lines
8537: WHERE budget_version_id = c_budget_version_id
8538: AND resource_assignment_id = c_resource_assignment_id
8539: AND TXN_CURRENCY_CODE = p_currency_code
8540: AND p_as_of_date BETWEEN start_date and end_date

Line 10148: pa_budget_lines bl,

10144: pa_proj_element_versions pev,
10145: pa_proj_elements pe,
10146: pa_resource_assignments ra,
10147: pa_resource_list_members rlm,
10148: pa_budget_lines bl,
10149: pa_progress_rollup pr
10150: WHERE
10151: pev.parent_structure_version_id = p_struct_ver_id AND
10152: pe.proj_element_id = pev.proj_element_id AND

Line 11595: FROM pa_budget_lines pbl,

11591: x_rawcost_pc,
11592: x_brdncost_pc,
11593: x_rawcost_fc,
11594: x_brdncost_fc
11595: FROM pa_budget_lines pbl,
11596: pa_resource_assignments pra
11597: WHERE pra.budget_version_id=p_budget_version_id
11598: AND pra.project_id=p_project_id
11599: AND pra.task_id=p_task_id