APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 3208: FROM pa_resource_lists_all_bg rlab, pa_resource_lists rl

3204: AND pev.element_version_id = temp.targ_elem_ver_id;
3205:
3206: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS
3207: SELECT decode(rlab.control_flag, 'Y', 'N', 'Y'), rl.uncategorized_flag
3208: FROM pa_resource_lists_all_bg rlab, pa_resource_lists rl
3209: WHERE rlab.resource_list_id = c_resource_list_id
3210: AND rlab.resource_list_id = rl.resource_list_id;
3211:
3212: l_rl_proj_specific_flag VARCHAR2(1);

Line 6697: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL

6693: -- a)PA_PLANNING_RESOURCE_UTILS.Get_Res_Format_for_Team_Role
6694: -- b)AssignmentUtils.getPLSMissingMsg in java
6695:
6696: FUNCTION is_uncategorized_res_list
6697: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6698: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6699: ) RETURN VARCHAR2 IS
6700:
6701: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

Line 6701: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

6697: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6698: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6699: ) RETURN VARCHAR2 IS
6700:
6701: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6702: IS
6703: SELECT UNCATEGORIZED_FLAG
6704: FROM pa_resource_lists_all_bg
6705: WHERE RESOURCE_LIST_ID = c_resource_list_id;

Line 6704: FROM pa_resource_lists_all_bg

6700:
6701: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6702: IS
6703: SELECT UNCATEGORIZED_FLAG
6704: FROM pa_resource_lists_all_bg
6705: WHERE RESOURCE_LIST_ID = c_resource_list_id;
6706:
6707: l_uncat_flag VARCHAR2(1) := 'N';
6708: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 6708: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

6704: FROM pa_resource_lists_all_bg
6705: WHERE RESOURCE_LIST_ID = c_resource_list_id;
6706:
6707: l_uncat_flag VARCHAR2(1) := 'N';
6708: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
6709: BEGIN
6710: l_resource_list_id := p_resource_list_id;
6711:
6712: IF l_resource_list_id IS NULL THEN