APPS.PA_TASK_ASSIGNMENTS_PVT dependencies on PA_BUDGET_LINES

Line 61: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

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

Line 1068: delete from pa_budget_lines

1064: CLOSE C_Prog_Date;
1065:
1066: -- Bug 3954155 Should not access a closed cursor
1067: IF C_Prog_Date_Rec.as_of_date IS NOT NULL THEN
1068: delete from pa_budget_lines
1069: where resource_assignment_id = l_resource_assignment_id_tbl(i)
1070: and start_date > C_Prog_Date_Rec.as_of_date;
1071: ELSE
1072: delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);

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

1068: delete from pa_budget_lines
1069: where resource_assignment_id = l_resource_assignment_id_tbl(i)
1070: and start_date > C_Prog_Date_Rec.as_of_date;
1071: ELSE
1072: delete from pa_budget_lines where resource_assignment_id = l_resource_assignment_id_tbl(i);
1073: END IF;
1074:
1075: update pa_resource_assignments set sp_fixed_date=null,spread_curve_id =null, record_version_number=(record_version_number+1)
1076: where resource_assignment_id = l_FINPLAN_LINES_TAB(l_finplan_line_count).resource_assignment_id;

Line 1590: FROM pa_budget_lines

1586: AND ev.element_version_id = p_task_version_id;
1587:
1588: CURSOR get_txn_cur_code(c_resource_assignment_id NUMBER) IS
1589: SELECT txn_currency_code
1590: FROM pa_budget_lines
1591: where resource_assignment_id = c_resource_assignment_id
1592: and txn_currency_code is not null
1593: and rownum = 1;
1594: