APPS.PA_TASK_ASSIGNMENT_UTILS dependencies on PA_RESOURCE_LISTS

Line 3323: FROM pa_resource_lists_all_bg rlab, pa_resource_lists rl

3319: AND pev.element_version_id = temp.targ_elem_ver_id;
3320:
3321: CURSOR get_rl_proj_specific_flag(c_resource_list_id NUMBER) IS
3322: SELECT decode(rlab.control_flag, 'Y', 'N', 'Y'), rl.uncategorized_flag
3323: FROM pa_resource_lists_all_bg rlab, pa_resource_lists rl
3324: WHERE rlab.resource_list_id = c_resource_list_id
3325: AND rlab.resource_list_id = rl.resource_list_id;
3326:
3327: l_rl_proj_specific_flag VARCHAR2(1);

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

6818: -- a)PA_PLANNING_RESOURCE_UTILS.Get_Res_Format_for_Team_Role
6819: -- b)AssignmentUtils.getPLSMissingMsg in java
6820:
6821: FUNCTION is_uncategorized_res_list
6822: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6823: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6824: ) RETURN VARCHAR2 IS
6825:
6826: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)

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

6822: ( p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE := NULL
6823: ,p_project_id IN pa_projects_all.project_id%TYPE := NULL
6824: ) RETURN VARCHAR2 IS
6825:
6826: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6827: IS
6828: SELECT UNCATEGORIZED_FLAG
6829: FROM pa_resource_lists_all_bg
6830: WHERE RESOURCE_LIST_ID = c_resource_list_id;

Line 6829: FROM pa_resource_lists_all_bg

6825:
6826: CURSOR get_uncat_flag (c_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE)
6827: IS
6828: SELECT UNCATEGORIZED_FLAG
6829: FROM pa_resource_lists_all_bg
6830: WHERE RESOURCE_LIST_ID = c_resource_list_id;
6831:
6832: l_uncat_flag VARCHAR2(1) := 'N';
6833: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

Line 6833: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;

6829: FROM pa_resource_lists_all_bg
6830: WHERE RESOURCE_LIST_ID = c_resource_list_id;
6831:
6832: l_uncat_flag VARCHAR2(1) := 'N';
6833: l_resource_list_id pa_resource_lists_all_bg.resource_list_id%TYPE;
6834: BEGIN
6835: l_resource_list_id := p_resource_list_id;
6836:
6837: IF l_resource_list_id IS NULL THEN