APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,

82:
83: =======================================================================*/
84: PROCEDURE Get_Res_Class_Rlm_Ids
85: (p_project_id IN pa_projects_all.project_id%TYPE,
86: p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE,
87: x_people_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
88: x_equip_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
89: x_fin_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895
90: x_mat_res_class_rlm_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE, --File.Sql.39 bug 4440895

Line 110: FROM pa_resource_lists_all_bg

106: CURSOR c_rlm_ids IS
107: SELECT resource_list_member_id, resource_class_code
108: FROM pa_resource_list_members,
109: (SELECT control_flag
110: FROM pa_resource_lists_all_bg
111: WHERE resource_list_id = p_resource_list_id) rl_control_flag
112: WHERE resource_list_id = p_resource_list_id
113: AND ((rl_control_flag.control_flag = 'N' AND
114: object_type = 'PROJECT' AND