APPS.PA_RATE_ATTR_PKG dependencies on PA_RESOURCE_LIST_MEMBERS

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 47: TYPE rbs_element_id_tbl is table of pa_resource_list_members.migrated_rbs_element_id%type

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
48: index by binary_integer;
49: l_rbs_element_id_tbl rbs_element_id_tbl;
50:
51: TYPE max_date_tbl is table of pa_proj_period_profiles.period1_start_date%TYPE