APPS.PA_ROLE_LIST_UTILS dependencies on PA_ROLE_LISTS

Line 21: FROM pa_role_lists

17: IF p_role_list_id IS NOT NULL AND p_role_list_id <> FND_API.G_MISS_NUM THEN
18: IF p_check_id_flag <> 'N' THEN
19: SELECT role_list_id
20: INTO x_role_list_id
21: FROM pa_role_lists
22: WHERE role_list_id = p_role_list_id
23: AND TRUNC(start_date_active) <= l_sysdate
24: AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));
25: ELSE

Line 31: FROM pa_role_lists

27: END IF;
28: ELSE
29: SELECT role_list_id
30: INTO x_role_list_id
31: FROM pa_role_lists
32: WHERE name = p_role_list_name
33: AND TRUNC(start_date_active) <= l_sysdate
34: AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));
35: END IF;