APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_BUDGET_LINES

Line 62: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

58: l_burdened_cost_tbl system.pa_num_tbl_type := system.pa_num_tbl_type();
59:
60: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
61:
62: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
63:
64: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
65: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
66: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;

Line 1235: -- delete from pa_budget_lines

1231: */
1232:
1233: -- Bug 3954155 Should not access a closed cursor
1234: -- IF C_Prog_Date_Rec.as_of_date IS NOT NULL THEN
1235: -- delete from pa_budget_lines
1236: -- where resource_assignment_id = l_resource_assignment_id_tbl(i)
1237: -- and start_date > C_Prog_Date_Rec.as_of_date;
1238: -- ELSE
1239: -- delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);

Line 1239: -- delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);

1235: -- delete from pa_budget_lines
1236: -- where resource_assignment_id = l_resource_assignment_id_tbl(i)
1237: -- and start_date > C_Prog_Date_Rec.as_of_date;
1238: -- ELSE
1239: -- delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);
1240: -- END IF;
1241:
1242: /* commented for bug#13059417
1243: update pa_resource_assignments set sp_fixed_date=null,spread_curve_id =null, record_version_number=(record_version_number+1)

Line 1814: FROM pa_budget_lines

1810: AND ev.element_version_id = p_task_version_id;
1811:
1812: CURSOR get_txn_cur_code(c_resource_assignment_id NUMBER) IS
1813: SELECT txn_currency_code
1814: FROM pa_budget_lines
1815: where resource_assignment_id = c_resource_assignment_id
1816: and txn_currency_code is not null
1817: and rownum = 1;
1818: