APPS.PA_PROGRESS_UTILS dependencies on PA_BUDGET_LINES

Line 3016: FROM pa_budget_lines

3012: projfunc_cost_rate_type,
3013: projfunc_cost_rate_date_type,
3014: projfunc_cost_rate_date,
3015: projfunc_cost_exchange_rate
3016: FROM pa_budget_lines
3017: where budget_version_id = c_budget_version_id
3018: and resource_assignment_id = c_res_assignment_id
3019: and c_as_of_date between start_date and end_date
3020: and txn_currency_code = c_txn_curr_code;

Line 8490: FROM pa_budget_lines

8486: CURSOR get_override_rate ( c_budget_version_id NUMBER, c_resource_assignment_id NUMBER )
8487: IS
8488: SELECT NVL(TXN_COST_RATE_OVERRIDE,TXN_STANDARD_COST_RATE) -- Bug 3951555, Added nvl and TXN_STANDARD_COST_RATE
8489: , nvl(BURDEN_COST_RATE_OVERRIDE, BURDEN_COST_RATE) -- Bug 3951555, Added nvl and BURDEN_COST_RATE
8490: FROM pa_budget_lines
8491: WHERE budget_version_id = c_budget_version_id
8492: AND resource_assignment_id = c_resource_assignment_id
8493: AND TXN_CURRENCY_CODE = p_currency_code
8494: AND p_as_of_date BETWEEN start_date and end_date

Line 10074: pa_budget_lines bl,

10070: pa_proj_element_versions pev,
10071: pa_proj_elements pe,
10072: pa_resource_assignments ra,
10073: pa_resource_list_members rlm,
10074: pa_budget_lines bl,
10075: pa_progress_rollup pr
10076: WHERE
10077: pev.parent_structure_version_id = p_struct_ver_id AND
10078: pe.proj_element_id = pev.proj_element_id AND

Line 11516: FROM pa_budget_lines pbl,

11512: x_rawcost_pc,
11513: x_brdncost_pc,
11514: x_rawcost_fc,
11515: x_brdncost_fc
11516: FROM pa_budget_lines pbl,
11517: pa_resource_assignments pra
11518: WHERE pra.budget_version_id=p_budget_version_id
11519: AND pra.project_id=p_project_id
11520: AND pra.task_id=p_task_id