APPS.PA_RATE_ATTR_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 20: and exists (select 'X' from pa_resource_assignments ra

16: select bv.budget_version_id,bv.project_id,bv.resource_list_id
17: from pa_budget_versions bv
18: where bv.fin_plan_type_id is not null
19: and bv.budget_version_id = c_budget_version_id
20: and exists (select 'X' from pa_resource_assignments ra
21: where bv.budget_version_id = ra.budget_version_id);
22:
23: -- End Bug 3787658, 06-AUG-2004, jwhite ----------------------------------------------
24:

Line 30: from pa_resource_assignments ra,pa_resource_list_members rlm,pa_budget_lines bl

26: cursor get_res_assign_id_csr(c_budget_version_id pa_budget_versions.budget_version_id%type, c_project_id pa_projects_all.project_id%type) is
27: select ra.resource_assignment_id,ra.resource_list_member_id,
28: rlm.migrated_rbs_element_id,
29: min(bl.start_date) min_date,max(bl.end_date) max_date
30: from pa_resource_assignments ra,pa_resource_list_members rlm,pa_budget_lines bl
31: where ra.budget_version_id = c_budget_version_id and
32: ra.project_id = c_project_id
33: AND ra.resource_list_member_id = rlm.resource_list_member_id
34: AND rlm.res_format_id is not null -- Added for bug#4765774

Line 43: TYPE res_assign_id_tbl is table of pa_resource_assignments.resource_assignment_id%type

39:
40: -- End Bug 3787658, 06-AUG-2004, jwhite -------------------------------------------------
41:
42:
43: TYPE res_assign_id_tbl is table of pa_resource_assignments.resource_assignment_id%type
44: index by binary_integer;
45: l_res_assign_id_tbl res_assign_id_tbl;
46:
47: TYPE rbs_element_id_tbl is table of pa_resource_list_members.migrated_rbs_element_id%type

Line 296: pa_debug.g_err_stage := 'Updating pa_resource_assignments table';

292: -- Check if the called API returns succes
293: if (l_return_status = 'S') then
294:
295: IF l_debug_mode = 'Y' THEN
296: pa_debug.g_err_stage := 'Updating pa_resource_assignments table';
297: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
298: END IF;
299:
300:

Line 302: update pa_resource_assignments

298: END IF;
299:
300:
301: FORALL j IN l_res_assign_id_tbl.FIRST..l_res_assign_id_tbl.LAST
302: update pa_resource_assignments
303: set
304: record_version_number = record_version_number + 1,
305: rbs_element_id = l_rbs_element_id_tbl(j),
306: resource_class_code = l_resource_class_code_tbl(j) ,