APPS.PA_ROLE_LIST_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 19

      SELECT role_list_id
      INTO x_role_list_id
      FROM pa_role_lists
      WHERE role_list_id = p_role_list_id
      AND TRUNC(start_date_active) <= l_sysdate
      AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));

Line: 29

    SELECT role_list_id
    INTO x_role_list_id
    FROM pa_role_lists
    WHERE name = p_role_list_name
    AND TRUNC(start_date_active) <= l_sysdate
    AND (end_date_active IS NULL OR l_sysdate <= TRUNC(end_date_active));