DBA Data[Home] [Help]

APPS.PA_RATE_ATTR_PKG dependencies on PA_BUDGET_LINES

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